Supply & Demand Planning Analyst

Position: Supply & Demand Planning Analyst

Position Overview:

We are seeking a Supply & Demand Planning Analyst to manage forecasting, inventory planning, replenishment, inventory to budget planning, and supply chain coordination across multiple product categories, brands, and sales channels.

This role ensures optimal stock levels, minimizes out-of-stocks, forecast and maintain purchasing budget, and provides data-driven insights to guide purchasing and production planning to ensure On Time and In Full delivery to customers.

The ideal candidate has experience in consumer-packaged goods (CPG) forecasting, inventory management, purchasing budget creation and adherence, Microsoft Dynamics 365 Business Central, and working with data-driven planning tools. Need to have expert level capability in Microsoft excel.

Key Responsibilities:

a. Demand Planning & Forecasting

1. Develop short- and long-term demand forecasts based on future looking sales forecast, sales history, retailer programs, seasonal trends, and product lifecycle data.

2. Partner with Vendors, Sales, Logistics, and Finance to align on forecast assumptions and demand signals.

3. Maintain Stock Keeping Unit (SKU)-level forecasting models for multiple brands and product categories.

b. Inventory Management

1. Monitor inventory levels across warehouses, ensuring optimal stock availability for E-commerce and retail partner orders.

2. Track inbound Purchase Orders (POs) and production schedules to ensure timely replenishment.

3. Identify potential stockouts, overstock risks, and supply gaps, escalating to leadership when necessary.

c. Supply Coordination

1. Support PO planning with vendors, manufacturers, and licensing partners.

2. Coordinate timelines for production, packaging, shipping, warehouse receipt, and on time customer deliveries (from PO issuance to final customer delivery).

3. Ensure demand plans align with vendor lead times and minimum order quantities.

d. Reporting & Analytics

1. Create and maintain dashboards for SKU performance, forecast accuracy, and inventory turns.

2. Prepare weekly and monthly supply chain reports for leadership.

3. Provide insights on product performance, slow movers, and demand trends.

e. Cross-Functional Collaboration

1. Work closely with Sales on retailer forecasts, promotions, and new product launches.

2. Partner with Operations to ensure supply continuity and prevent fulfillment bottlenecks.

3. Collaborate with Finance on Cost of Goods Sold (COGS), forecast variance, and purchasing budgets.

Qualifications

1. 3+ years of supply chain, demand planning, or inventory management experience (CPG preferred).

2. Strong analytical skills with expert proficiency in Excel and Business Central 365.

3. Experience with forecasting models, inventory optimization, and SKU-level planning.

4. High attention to detail with the ability to manage multiple product lines in a fast-paced environment.

5. Strong communication and ability to coordinate across multiple teams.

Benefits:

Paid training

Work Location: Hybrid remote in Davao City