Demand Planner

Requirements:Proven experience on QlickView5-6 years in demand planning within Retail and/or FMCGNational Diploma in Supply ChainAdvanced excel skillsDuties include:Monthly reports on Qlikview, forecastsMaster Data Clean up weekly via QlikviewManaging the Qlikview classifications by ensuring that obsolete and excess stock is reduced and the correct holding for good stock is optimised.Develop effective forecast models based on trends and demand patternsCalculate stock volume requirements according to minimum order quantities, stock-on-hand, promotional requirements, price increases, best delivery practice etcPropose and implement solutions and inventory estimations to ManagementPlace and follow up on stock ordered with suppliers to minimise lost sales and avoid stock outagesSuccessfully communicate forecast and inventory estimations to Management and get approvalLiaise with receiving regarding slot times, discrepancies, stock not ordered, short-supplied stock, bookings etcIdentify and report overstocks together with support to sales team in regard to exit strategy.Identify and report short-dated and exipred stock. Either IBT it to another DC or liaise with sales department to sell.Assist with queries regarding POs & GRV (receiving department)Fill in for team members on leaveSolve Ad hoc inventory issues/queries