Material Planner

TREMEC; Novi (MI); On-site; USD 70,000 - 100,000; Full time

Job summary

Tremec is seeking a Material Planner to develop and implement material plans for production, warehousing and delivery. You will work with suppliers and internal teams to optimize inventory levels and ensure on-time delivery.

The role requires 2–5 years in material planning within automotive manufacturing, and strong MRP familiarity with SAP/QAD/Oracle. Proficiency in MS Office is expected, with emphasis on Excel.

Qualifications

• 2-year degree required, 4-year degree preferred in Supply Chain, Engineering or Business.
• Requires 2-5 years of experience in material planning in an automotive manufacturing environment.
• MS Office, Word and Excel knowledge required.
• Working knowledge of MRP with SAP/QAD/Oracle and EDI transmissions.

Responsibilities

• Develop and implement material plans for production, warehousing, inventory and delivery to meet demand.
• Coordinate with Suppliers and Outside Processors on daily demand and delivery issues.
• Manage MRP, procurement, inventory control and warehousing activities.
• Establish inventory targets and implement KanBan to prevent stockouts and excess stock.
• Review supplier schedules and communicate changes to Master Scheduler and materials manager.
• Maintain Bill of Materials and parts information in SAP.

Education

2-year degree

4-year degree preferred in Supply Chain, Engineering or Business

Tools

SAP

QAD

Oracle

Job description

OBJECTIVE OF THE POSITION

Responsible to develop and implement material plans for production, warehousing, inventory levels and delivery to meet internal/external customer demand with consideration of working capital, timing and available resources.

ESSENTIAL FUNCTIONS

• Communicate with the Suppliers and Outside Processors on daily demand and delivery issues to include Invoice Concerns
• Manage activities related to material requirements planning (MRP), procurement, and inventory control and warehousing.
• Establish appropriate inventory targets and implement pull system (KanBan) where feasible to prevent stock outs and excess inventories
• Analyze and determine min/max levels of raw materials, WIP and finished goods in conjunction with master scheduler and capacity plan.
• Create dispute reports for premium freight, rating violations and additional incidents directed by Material Manager
• Monitor slow moving, obsolete and consigned material and adjust as required
• Complete behind Schedule Report with explanation of each occurrence and what is being done to correct issue
• Assist in counting, repacking, creating shippers and or labels when behind schedule to internal and external customers
• Review Supplier Schedules daily, high lighting increases and notifying Master Scheduler, Customer Service Reps and Materials Manager of all changes.
• Complete daily/weekly Supplier CUM reconciliation
• Create and Maintain Supplier Delivery Calendar updating changes weekly
• Enter all scheduled releases to Suppliers weekly listing demand changes and trending elements( check Supplier contracts as required)
• Provide data as required by Materials Manager
• Identify and coordinate Supplier schedule corrections and resolution with Program management, Purchasing, Engineering Change Coordinator and the Plant
• Assist Packaging Engineer with Container/Dunnage specifications and requirements
• Provide documented evidence of ongoing Supplier issues not resolved in a timely fashion (1 week)
• Ensure inventory locations for plant, warehouses and processors are accurate
• Track Hot Shipments for all Suppliers and coordinate critical timing and delivery to Production and Supply Chain Team members
• Assist Master Scheduler and Engineering Change Coordinator with Engineering changes and establishing break points. Reconcile demand/changes against breakpoints
• Assist in identifying/resolving contract issues for ECN, Label and shipping errors
• Notify Materials Manager of support issues and incomplete assignments/tasks
• Create daily follow-up task list and or action register to resolve open issues
• Participate in annual/semi-annual physical inventories as directed
• Maintain parts information in SAP
• Create and maintain Bill of Materials in SAP

SECONDARY FUNCTIONS

• Other duties assigned by supervisor

REQUIREMENTS PROFILE

Professional Background / Basic Qualifications / Work Experience

• 2 year degree required, 4 year degree preferred in Supply Chain, Engineering or Business
• Requires 2-5 years of experience material planning in an automotive manufacturing environment

Technical Expertise

• Working knowledge of MS Office, Word, and Excel
• Detailed understanding and experience in MRP with working knowledge of QAD, SAP, or Oracle with EDI transmissions. (SAP Preferred)