We are hiring a Senior Planner to own the Master Production Schedule (MPS) and raw material planning, so that customer orders ship on time. You will balance forecasts, customer demand and plant capacity, and give Purchasing timely material plans. Strong Excel skills are central to this role, including advanced functions, Power Query and macros, to automate planning reports and analysis.
Key responsibilities
- Prepare and maintain the Master Production Schedule (MPS) in line with sales forecasts, customer demand and available capacity.
- Ensure the MPS meets customer requirements and delivery dates, and adjust it when demand or capacity changes.
- Review and analyze raw material requirements against forecasts and actual orders, and give Purchasing timely material plans.
- Run planning in the ERP system (such as JDE), keeping planning data such as lead times, lot sizes and safety stock accurate.
- Build and maintain Excel planning tools, using advanced functions, Power Query and macros to automate data pulls, reports and dashboards.
- Track inventory levels, shortages and excess stock, and apply FIFO, JIT and lean principles to keep stock lean.
- Work with Sales, Purchasing, Production, Warehouse and Logistics to resolve supply and capacity issues.
- Report on planning KPIs such as on-time delivery, schedule adherence and inventory turns.
- Mentor junior planners and improve planning processes.
Requirements
- Diploma or bachelor's degree in Supply Chain Management, Logistics, Economics, Business Administration or a related field.
- Proficient in MS Excel, including advanced functions, Power Query and macros.
- Proficient in MS Office and the planning modules of ERP systems such as JDE.
- Familiar with process, product and demand planning.
- Familiar with FIFO, JIT and lean manufacturing principles.
- Experience preparing and maintaining a Master Production Schedule that meets customer requirements and delivery dates.
- Experience analyzing raw material requirements from forecasts and actual orders, and providing timely material plans to Purchasing.
If interested, please submit your application to ************* with your expected salary and resume.
We regret that only short-listed candidates will be contacted shortly. By submitting your application or resume, you agree to the collection, use, retention, and sharing of your personal information with potential employers for their assessment.
JDA WMS Pte Ltd | EA Personnel: Pham Thi Tuyet Mai
EA License No: 23S1595 | EA Registration No: R25127838