About the job Associate Demand Supply Planning
Demand Supply Planning
Working with: SCM Lead Indonesia, Trade Marketing Lead Indonesia, Country Sales Manager Indonesia, TM Sales Data Analyst, National Account Manager, Customer Service Executive Indonesia.
WORKING DAYS: 5-days work week; Mondays - Fridays
WORKING HOURS: 0900hrs to 1800hrs
This is an individual contributor role, with the following objectives:
- To develop a robust forecast of Primary Sales and Secondary Sales, of Indonesia business.
- To deliver / develop the corresponding supply planning executions (both import and local 3PM production).
- To deliver/ develop FG export supply planning (based on APAC sister companies net requirement forecast).
- To support Supply Chain Management Lead Indonesia role, as deemed necessary.
Responsibilities:
- Develop a robust Secondary Sales forecast, using statistical model (if applicable), based on historical Independent Demand data, by SKU, by customer/channel, on a monthly basis.
- Develop a robust Primary Sales forecast, using statistical model (if applicable), based on historical Independent Demand data, by SKU, by customer/channel, on a monthly basis.
- Conduct a monthly pre-S&OP discussion of these 2 forecasts (also on the forecasts KPIs), in comparison with the Annual Operation Plan, with the TM Lead, Country Sales Manager Indonesia, NAM Indonesia and SCM Lead Indonesia.
- Develop/propose a gap-closing action between SS forecast and AOP, and between PS forecast and AOP.
- Conduct a monthly S&OP discussion of these 2 forecasts (SS and PS), its AOP-gap-closing action, the proposed M+0 Primary Sales detail list, and reflect the agreement in the revised SS and PS forecast of M+1 onwards.
- Based on the revised PS forecast, and considering the current stock on hand, develop a net requirement supply planning forecast for all SKUs.
- Considering the import ordering lead-time, create Purchase Order in order management system for all imported FGs.
- Issue Purchase Order to local 3PM, for FG SKUs produced locally for M+0 and M+1.
- Share the net requirement supply planning forecast (of M+2 onwards) to local 3PM.
- Run Material Requirement Planning for all RM/PM requirements of locally produced FG.
- Issue RM Purchase Order to either overseas or local vendors.
- Issue PM Purchase Order to either overseas or local vendors.
- Together with SCM Lead Indonesia, conduct monthly stock reconciliation of FG, RM and PM, including inventory stock counting every 6 months (mid-year and November).
- Perform all administrative duties and purchasing process in SAP and Internal Systems in relevance to the supply chain operations (e.g. material master management).
- Support SCM Lead Indonesia for any other SCM task as requested and represent SCM Lead Indonesia during his absence (ad-hoc basis).
Requirements:
- At least 2 years or more working experience in demand planning, supply planning or supply chain management preferably in the Cosmetic and Supplement Industry.
- Possesses good written and communication skills in English.
- Compulsory knowledge of SAP & MS Office.
- Detail-oriented, very good with numbers and passionate about sales/business.
- Willing to learn new things, quick thinking, fast learner and adaptable.
- Knowledge of statistical forecasting models will be valuable but not mandatory, as this can be learned along the way.