Interim Material Planner

BrainWorks

Denver (CO)

On-site

USD 85,000 - 115,000

Full time

5 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

BrainWorks is seeking a Materials Planner for a non-turnkey co-manufacturing setup in Denver, CO. This role translates production needs into material requirements, manages supplier orders, and coordinates cross-functional activities across planning, procurement, quality, R&D, and finance to ensure on-time production.

The successful candidate will maintain coman-specific MRP models, optimize inventory, and resolve material shortages through proactive collaboration with suppliers and internal

Qualifications

  • MRP, purchasing, inventory control, and material lifecycle management.
  • Advanced Excel skills and Power BI experience.
  • Experience with D365 and Medius preferred; SharePoint familiarity.
  • Strong analytical and communication skills.

Responsibilities

  • Translate production requirements into material needs and coordinate execution across suppliers, comans, and diverse internal partners.
  • Create and manage ingredient and packaging purchase orders in D365 based on validated requirements.
  • Coordinate supplier orders and deliveries, and provide forward-looking demand visibility to suppliers.
  • Monitor inventory, receipts, PO status, and net requirements to manage shortages and overstock.
  • Maintain version control of models and perform scenario analyses for production changes.

Skills

MRP
Purchasing
Inventory control
Materials planning
D365
Excel
Power BI
Cross-functional collaboration

Tools

D365
Medius
Power BI
SharePoint
Excel

Job description

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr. Manager Production Planning & Materials
Sr. Manager Production Planning & Materials

Lightera • Carrollton (GA)

On-site
USD 120,000 - 180,000
Material Planner
Material Planner

Vollrath Careers • Kewaunee (WI)

On-site
USD 65,000 - 90,000
Materials Manager
Materials Manager

Mestek, Inc. • Dallas (TX)

On-site
USD 90,000 - 130,000
Materials Manager
Materials Manager

Mestek, Inc. • Dallas (TX)

On-site
USD 110,000 - 140,000
Materials Manager
Materials Manager

Louver Group • Dallas (TX)

On-site
USD 85,000 - 125,000
Senior Materials Planner
Senior Materials Planner

Amy's Kitchen • Petaluma (CA)

On-site
USD 75,000 - 113,000
Health benefits
401(k) with employer match
Tuition reimbursement
+6
Senior Materials Planner
Senior Materials Planner

Amy's Kitchen, Inc. • Petaluma (CA)

On-site
USD 75,000 - 113,000
Health plans (Medical, Dental, Vision)
FSA/HSAs
Mental health support
+9
Material Planner
Material Planner

The Lion Brewery • Pittston

Hybrid
USD 65,000 - 85,000
Material and Inventory Planner
Material and Inventory Planner

Kirby Company • Cleveland (OH)

On-site
USD 65,000 - 90,000
401(k) with company matching
Material Planner
Material Planner

The Vollrath Company • Kewaunee (WI)

On-site
USD 60,000 - 75,000