WHAT WE ARE LOOKING FOR
The Materials Planner, Non-Turnkey Co-Manufacturing ensures assigned co-manufacturing partners have the right ingredients and packaging available to execute production while controlling inventory and purchasing exposure. Because Simply Good Foods retains responsibility for material planning and procurement in the non-turnkey model, this role translates production requirements into material needs and coordinates execution across suppliers, comans, Supply Planning, Procurement, Finance, Quality, R&D, and Coman teams. The role maintains coman-specific MRP models, creates and manages purchase orders in Microsoft Dynamics 365 (D365), coordinates supplier orders and deliveries, and monitors inventory and open commitments. It also responds to supply and demand changes that may affect production and owns follow-through from requirements planning through delivery, receipt confirmation, inventory reconciliation, exception resolution, and transition closeout.
KEY RESPONSIBILITIES
- MRP and production readiness
- Maintain coman-specific MRP models that translate finished-good production plans into time-phased ingredient and packaging requirements.
- Own the recurring planning cycle by obtaining, validating, and reconciling updated production requirements, inventory, open-order status, receipts, consumption, and formula or packaging changes with the responsible partners.
- Validate production volumes, formulas/BOMs, usage rates, yields, scrap assumptions, material mappings, lead times, MOQs, pack sizes, and other planning parameters before finalizing material requirements and purchasing actions.
- Incorporate current inventory, open purchase orders, receipts, production consumption, approved forecast overrides, and known supply constraints to calculate net requirements and projected shortages.
- Maintain version control and validate changes to model logic, formulas, mappings, assumptions, and manual overrides.
- Perform ad-hoc material feasibility and scenario analysis for production pull-ins, push-outs, volume changes, alternate schedules, new items, formula changes, and recovery plans.
- Review available production and material consumption data to identify variances, model issues, inaccurate usage assumptions, or transactions requiring follow-up.
Purchasing, supplier coordination, and delivery execution
- Create and maintain ingredient and packaging purchase orders in D365 based on validated material requirements and approved purchasing parameters.
- Issue purchase orders to suppliers and obtain confirmation of price, quantity, requested delivery date, ship-to location, and applicable supplier or coman reference numbers.
- Provide suppliers with appropriate forward-looking material demand visibility and communicate changes that may affect capacity, lead time, pricing, or delivery timing.
- Keep purchase-order status aligned and current in D365 and the applicable MRP model or tracker through completion. Maintain accurate quantities, expected delivery dates, prepayment requirements, changes, partial receipts, cancellations, remaining balances, and closeout status.
- Adjust order quantities and timing based on MOQs, pack sizes, tiered pricing, freight considerations, inventory targets, shelf life, and changing production needs.
- Coordinate delivery and receiving requirements, including ship-to locations, coman reference numbers, delivery appointments, temporary storage, and supporting documentation.
- When supplier timing will not support production, coordinate material transfers or alternate supply paths. Escalate supplier capability, quality approval, prepayment, pricing, shelf-life, or commercial issues to the appropriate owner when they require decisions or action beyond the planner’s authority.
Inventory, receipts, and financial exception coordination
- Monitor coman inventory for ingredients and packaging, including on-hand, inbound, allocated, unreleased, and quality-hold quantities.
- Reconcile inventory, receipts, purchase orders, and consumption information. Confirm that delivered orders are reflected accurately in the MRP model, then coordinate D365 receipt or closeout follow-up with the responsible teams.
- Partner with Finance to resolve receipt, invoice, pricing, quantity, three-way match, prepayment, and inventory ownership exceptions.
- Maintain visibility to unresolved transactions, material variances, and inventory or purchasing exposure.
- Maintain clear supporting documentation for material decisions, substitutions, purchasing changes, inventory adjustments, and exception resolution.
Transitions, aged inventory, and master data alignment
- Evaluate demand, inventory, open orders, supplier timing, shelf life, and production requirements to recommend material run-out and cut-in timing.
- For ingredient and packaging transitions, evaluate demand, inventory, open orders, supplier timing, shelf life, and production requirements. Use that analysis to recommend material run-out and cut-in timing for formula or specification changes, supplier changes, item replacements, branded-to-generic conversions, new product launches, and discontinuations.
- Coordinate required purchasing changes, transfers, depletion, extensions, alternate-use evaluation, or disposition follow-up with the responsible Procurement, Quality, R&D, Finance, Planning, and Coman partners.
- Monitor aged, expiring, excess, and obsolete inventory and maintain visibility to exposure, decisions, and agreed actions.
- Maintain alignment among D365 item numbers, supplier item numbers, coman resource codes, descriptions, units of measure, formulas/BOMs, and reporting outputs.
- Support setup and validation of new materials, suppliers, ship-to locations, pricing, and other master data dependencies required for ordering and reporting.
Coman coordination, issue management, and process improvement
- Serve as the primary day-to-day materials planning and purchasing contact, alongside the Coman Manager, for assigned non-turnkey coman operations.
- Coordinate resolution of material shortages and operational exceptions, aligning the appropriate partners on production impact, mitigation, decisions, ownership, and timing.
- Maintain the standard work, planning calendars, trackers, decision records, and process documentation needed to support consistent execution and continuity.
- Recommend practical improvements to planning models, reporting, data quality, and ways of working as opportunities are identified.
KNOWLEDGE / ABILITIES
- Strong working knowledge of MRP, purchasing, inventory control, production planning, supplier management, and material lifecycle management.
- Advanced Microsoft Excel skills, including Power Query, lookups, pivot tables, structured data, exception analysis, and reconciliation of large data sets.
- Demonstrated working knowledge of ERP-based purchasing, inventory transactions, and invoice-exception workflows is required. Experience with Microsoft Dynamics 365 (D365) and Medius is strongly preferred. Experience working with SharePoint-based files and reporting tools such as Power BI is expected; familiarity with the Anaplan planning platform is preferred.
- Strong analytical judgment and attention to detail, with the ability to trace discrepancies across item, formula, supplier, PO, receipt, lot, UOM, and inventory records.
- Clear, proactive communication with suppliers, comans, and internal stakeholders, with the ability to drive follow-up without direct authority.
- Ability to prioritize production-critical work while managing recurring planning cycles, transactional execution, and unplanned exceptions.
- Ability to work effectively in a manual or evolving process environment while developing practical structure, documentation, and controls.
BrainWorks, a Top 50 Hunt Scanlon executive search firm, has been delivering superior talent for over three decades to drive business performance. Our consultants are true experts in their fields, specializing in Consumer Products, Analytics, Accounting and Finance, Information Technology, Private Equity and Corporate Development, Sales and Marketing.
We pride ourselves on delivering quality, speed, and results through our proven recruitment process. When you partner with BrainWorks, you gain trusted consultants who combine industry expertise with a commitment to understanding your business needs. Visit us at brainworksinc.com.
#LI-JK1
#LI-DNI