Supply Planning Analyst

Kopi Kenangan; Jakarta Selatan; On-site; IDR 200,880,000 - 312,480,000; Full time

Job summary

Kopi Kenangan is seeking a detail-oriented Supply Planning Analyst to own inventory and supply planning across regional warehouses, balancing dry materials, packaging, small wares, and perishables to ensure stock availability.

The ideal candidate has a Bachelor's degree in a related field, 2–3 years in FMCG or retail, advanced Excel skills, and a data-driven mindset to translate demand forecasts into actionable Purchase Orders and optimized stock levels.

Qualifications

• Bachelor's degree in Industrial Engineering, Supply Chain Management, Logistics, or a related field.
• 2–3 years in FMCG, Retail, or F&B with exposure to material planning, inventory management, or supply planning.
• Highly proficient in MS Excel (Sum-If, LOOKUPs, Pivot Tables, data validation, nested formulas, scenario modeling).
• Strong analytical capabilities with meticulous attention to detail and a data-driven approach to stock optimization.
• Excellent communication and stakeholder management; collaborative and proactive in a fast-paced retail environment.

Responsibilities

• Regional Inventory Management: Monitor supply planning and inventory across 3–4 regional warehouses for packaging, dry raw materials, small wares, and low-volume perishables.
• Forecast Translation & PO Execution: Review demand forecasts, evaluate stock balances, determine vendor order quantities, and place/track POs.
• Safety Stock & Flow Optimization: Analyze inventory to maintain target safety stock and prevent stockouts or overstocking.
• Data Integrity & Reporting: Maintain accurate SCM system data and generate reports on inventory movements, stock cover, lead times, and fulfillment performance.
• Risk Mitigation & Collaboration: Identify bottlenecks early and liaise with vendors and logistics to resolve delays.

Skills

Advanced Excel

Inventory optimization

Demand forecasting

Education

Bachelor's in Industrial Engineering or related

Tools

ERP systems

Job description

Kopi Kenangan is seeking a detail-oriented, data-driven Supply Planning Analyst to join our Supply Chain team. In this role, you will owner inventory and supply planning across regional warehouses—balancing dry materials, packaging, small wares, and low-volume perishables to ensure seamless stock availability. If you excel at advanced Excel modeling, inventory optimization, and translating demand forecasts into actionable purchase plans, step into this vital role with us!

Ideal Candidate Profile:

• Education: Bachelor's degree, preferably in Industrial Engineering, Supply Chain Management, Logistics, or a related field.
• Experience: 2 to 3 years of experience in FMCG, Retail, or F&B with direct exposure to material planning, inventory management, or supply planning.
• Advanced Excel Proficiency: Must be highly proficient in MS Excel (Sum-If, LOOKUPs, Pivot Tables, data validation, nested formulas, and scenario modeling).
• Core Competencies: Strong analytical capabilities, meticulous attention to detail, and a structured, data-driven approach to stock optimization.
• Soft Skills: Excellent communication and stakeholder management skills; collaborative, proactive, and adaptable in a fast-paced retail ecosystem.

Job Role:

• Regional Inventory Management: Manage supply planning and inventory monitoring across 3 to 4 regional warehouses, focusing on packaging, dry raw materials, small wares, and low-volume perishables.
• Forecast Translation & PO Execution: Review demand forecasts from the demand planning team, evaluate stock balances, determine vendor order quantities, and place/track Purchase Orders (POs).
• Safety Stock & Flow Optimization: Perform continuous inventory analysis across central and satellite fulfillment centers to maintain target safety stock levels while preventing stockouts or overstocking.
• Data Integrity & Reporting: Maintain accurate supply chain system data and generate regular reports on inventory movements, stock cover, supplier lead times, and fulfillment performance.
• Risk Mitigation & Collaboration: Identify supply bottlenecks early, flag potential stock shortages to cross-functional teams, and collaborate with vendors and logistics partners to resolve delays promptly.
• Kopi Kenangan: 1,200+ outlets across Indonesia
• Kenangan Coffee Malaysia: 200+ store locations
• Kenangan Coffee Singapore: 10 locations and growing
• Kenangan Coffee India: 10 stores and aggressive expansion plans
• Global Footprint: Expanding footprint across Taiwan, Australia, and the Philippines