Production Planner Executive

Key Responsibilities

1. Line Planning & Scheduling

• Receive customer delivery notes/POs and plan daily loading by part, quantity and due date
• Plan hanger/rack loading to maximise line fill rate (pcs per hanger, hangers per hour) based on line speed and part size
• Sequence jobs to minimise changeovers (part geometry, jig change, film thickness spec, curing profile)
• Schedule rework/re-coat and stripping jobs without disrupting main production
• Coordinate line downtime for bath maintenance, tank cleaning and chemical top-up with Line Supervisor
• Update daily delivery schedule and alert Sales early on any delay

2. Customer Part Control (Consigned Stock)

• Record incoming customer parts accurately at receiving — part no., qty, customer DO no., condition (rust, damage, oil)
• Track every lot through stages: incoming → pretreatment → ED → curing → QC → packing → outgoing
• Ensure full reconciliation per lot: Qty In = Good Out + Reject + Rework + Balance on Hand
• Report damaged/non-conforming incoming parts to customer before processing
• Prepare outgoing DO and support billing data (pcs, m² or per-hanger basis)

3. Chemical & Consumable Inventory

• Maintain stock of ED paint (resin, pigment paste), pretreatment chemicals (degreaser, zirconium/phosphate, activator), DI water consumables, masking, hangers/jigs and packaging
• Track chemical consumption vs throughput (e.g. kg paint per 1,000 m² or per 1,000 pcs) and flag abnormal usage
• Set and monitor reorder levels considering supplier lead time and shelf life
• Apply FIFO and track batch/expiry dates of chemicals
• Raise PRs to Purchaser; verify GRN against PO
• Monthly stock count of chemicals and consumables; explain variances

4. Reporting (Excel + System)

• Daily: output vs plan, hanger utilisation %, WIP by customer, reject qty
• Weekly: OTD %, backlog by customer, line downtime summary
• Monthly: customer part reconciliation, chemical consumption ratio, reject/rework rate by customer and defect type, inventory value
• Maintain master data: customer part list, pcs per hanger, surface area per part, coating spec, price basis

5. Compliance

• Maintain traceability records for customer audits and PPAP/automotive requirements
• Follow ISO/QMS, SOPs and chemical handling (SDS, CHRA) requirements in coordination with ESH Officer

KPIs

• On-time delivery ≥ 95%
• Customer part reconciliation 100% (zero unexplained loss)
• Hanger/line utilisation ≥ 85%
• Zero line stoppage due to chemical shortage
• Chemical consumption within ±5% of standard

Requirements

• Diploma/Degree in Manufacturing, Chemical/Industrial Engineering, Supply Chain or related
• 2–4 years as PC/Production Planner in a coating, plating, painting, anodising or surface treatment line (job-coater environment strongly preferred)
• Understands ED process flow (pretreatment, electrodeposition, UF rinse, curing) at a working level
• Excel (must): SUMIFS/COUNTIFS, XLOOKUP/VLOOKUP, Pivot Table, conditional formatting, data validation
• Inventory/ERP system (must): hands-on with AutoCount, SQL Account, SAP B1 or similar, including consignment/customer-owned stock handling
• BM and English required
• Meticulous with numbers; comfortable working on the shop floor