Greater Melbourne Area
Supply Planning Purchasing Supply Chain Management
Forecasting Perform monthly rolling forecast for 20,000 SKUs for 400 customers nationally Create and maintain forecast model, incorporating business intelligence and forecast information gathered from 12 account managers and other sources (marketing, retail and product development) Gather, analyze and validate the raw data from ERP system (Dynamics AX) and execute the forecast modeling in Demand Solutions Review monthly forecast results with all account managers and achieve consensus with sales team and finance team Review forecast exceptions and recommend adjustments Review promotional plans with sales and marketing departments Monitor forecast accuracy, correct forecast errors and prepare relevant materials to facilitate research and discussion Capture the forecast from sales team for new SKUs and new customers Planning Supplier co-design cost and quotation analysis for NDP items Analysis of long-lead time SKUs: work closely with suppliers to set a long-term purchasing plan Preparing purchasing reports for management meetings (including DIFOT dashboard report, 12-month order planning, supplier capacity planning report, etc.) Identify cost-saving opportunities (renegotiate purchase prices with suppliers for high-volume SKUs, consolidate POs to reduce shipment costs, well manage lead time to minimize surcharge for urgent small orders, etc.) Inventory Planning: Safety stock calculation based on the input of production rate, part lead time, delivery frequency, batch size, etc. Inventory forecast for new development products, customer special SKUs and extended lines Planning for raw materials, WIP and finished products Periodical tracking on inventory level; ongoing support to other teams to minimize the in-house stock to reduce the inventory cost and optimize stock turnover ratio
Business Reporting: Month-end business management analysis and weekly financial reporting Dashboard reporting including energy consumption, production volume tracking, labor expense tracking, etc. Coordination with operations and finance team to collect information for reporting Monthly SKU performance analysis and reporting Preparing production volume report and attainment report by working area Involved in the budget building for Y2013/14 and Y2014/15 Data Modeling and Analysis : Analysis of slow-moving stock, safety stock level and on-hold inventory Production and costing BOM reconciliation; monthly stocktake reconciliation Analysis of industrial result and accounting result in SAP on a monthly basis Variance analysis based on budget/actual comparison Wastage, line efficiency and labor tracking analysis Planning and Forecast: Forecast of the stock level of finished goods, working-in-progress and raw materials Forecasting customers’ demand according to the analysis of historical seasonal adjusted sales data Prediction of costs and expenses every month including production cost, external charges, overhead cost, etc.
Inward/outward stock management, stock movement arrangement and frequent communications with three 3rd party warehouses in VIC, QLD and WA Analysis of stock level, safety stock level, value of goods and storage expenses Coordination with sales, production and finance departments to ensure that a reasonable stock level is maintained, all sales orders are fulfilled and cash flow is optimized Managing stock transfer among warehouses, order allocation and distribution to customer’s DCs through ERP system (Pronto) o Monthly inventory reconciliation and reporting Frequent coordination with warehouses/DCs, transport managers and customer inventory controllers / re-buyers o Cost reduction by optimizing pallet space, consolidating orders and controlling lead time Baseline Forecasting and Promotion stock planning Production, demand and import planning