Distribution and Inventory Analyst

Full Job Description

Pilmico Foods Corporation & Gold Coin Management Holdings are the integrated agribusiness and food companies of Aboitiz Equity Ventures, Inc. (AEV). Gold Coin is now fully-managed and owned by Pilmico International and to date, it is the largest investment in the Asia-Pacific region in their shared history.

Pilmico comprises four divisions: Flour, Feeds, Farms, and Trading; enabling growth to its partners through its consistent quality products and unparalleled supporting services. Meanwhile, Gold Coin is a pioneer in animal nutrition and the manufacturing of scientifically-balanced animal feed in Asia.

With their combined strengths, Pilmico & Gold Coin represent one of the largest privately-owned agribusinesses in the region, with over 2,900 partners throughout the multitude of production facilities across 11 countries in Asia.

In its journey moving forward, the Aboitiz Group will drive change for a better world by advancing business and communities. Armed with Pilmico and Gold Coin's mission of feeding humanity, they aim to take a leadership position in innovating the food value chain in the Asia Pacific.

Ensures that the Purchased items are stored and distributed to the right locations. Analyzes and links the Demand Plan from Sales with the Supplies coming in from Demand & Supply (D&S) Planning and Procurement teams.

Ensures cost-efficiency on External Warehousing operations by daily simulating “should be” expenses, and reconciling with actual incurred expenses. Analyzes and investigates differences between Planned versus Actual External Warehousing costs. Links reconciled costs to Accounting/ Finance.

Performs governance on Overall Inventory and Available For Sales (AFS), encompasses (TMM and all External Warehouse sites. Ensures daily updating and accuracy of Overall Inventory and AFS--in SAP, Power BI and actual physical items in all sites, including TMM.

Drives strong coordination with Sales, Supply Chain, External Logistics Coordinators, TMM Team and External Warehousing Partners to ensure above objectives.

Education : With Bachelor’s Degree

Experience : At least a year of experience in related field or expertise

Licenses: NA

• Adept to analysis, planning and critical-thinking tasks
• Ability to collaborate and drive change/ improvements
• Detail-oriented
• Able to work in Cold Warehouse
• Organized and can lead proper safekeeping of documents and reports

1) Formulates proposal on Distribution Plan, then facilitates alignment with Sales and Supply Chain.

• Regularly gathers info from Procurement and D&S (specific Supply Chain teams) on the incoming purchases, especially for the upcoming 3-month horizon.
• Using capacity-planning, recent Sales historical data, and existing inventory of the same SKU arriving, propose a Distribution Plan.
• Initiates alignment discussions with Sales, alongside Supply Chain teams, to link to their updated Demand Plan. Historical Sales might no longer be applicable to the next months especially if actualized supply is different with the initial demand forecasts.
• Measures percentage (%) Served Orders by the intended External Warehouse site (aka Distribution Center, DC). Determines if the clustered clients or areas per DC indeed served the intended ones. Refine simulations and analysis on misaligned served orders per DC. Links with Sales if gaps in the Demand Plan were one of the root causes.

2) Performs Planned versus Actual Costings to ensure cost-efficiency in External Warehouse sites

• Daily simulates planned Warehousing costs in all External sites.
• Plots vital volume movements such as storage, handling-ins and handling-outs.
• Captures special activities such as boxing and labeling, and other necessary expenses such as National Meat Inspection Service (NMIS) fees and materials such as cling-wrappers--as all these must be taken into consideration in the Planned Simulations.
• Foreseen inevitable incremental costs (e.g., overtime) must be captured and analyzed as well.
• Captures and highlights bad costs (e.g., double-handling due to late cancellation of orders) incurred, and foreseen to be incurred based on requests from internal stakeholders. Shows cost-visibility on every External Warehousing request.
• Measures Pallet Efficiency in every External Warehouse. The target for imported items is 600 kg to 800 kg per pallet. Otherwise, investigate the root cause and push its achievement. Escalates and sends Incident Report on inefficient pallet usage--with Php/ Kg impact computation.
• Analyzes SKU-Pallet configuration, linked with the regular ordering habits of customers served in each DC. For example, a pallet must hold 2 SKUs instead of 1 since there is a particular client who regularly orders said 2 SKUs--with this, handling-out of another pallet is eradicated. Highlight Php/ Kg savings or benefits.
• Measures Php/ Kg incurred in every External Warehouse site. The Php/ Kg must be within the set target by the business unit. If actuals exceed the budget for External Warehousing costs, ensures understanding of the gaps and proposes improvement areas.

3) Processes External Warehouses’ billings in order to reconcile with the Planned or “should be” expenses

• Accurately and timely validates, reconciles, and endorses to immediate TL for approval of the actual costs. Gives analysis on Planned versus Actual. Should there be significant variances, justifies the reasons and gives improvements on better capturing costs during the daily Operations Planning stage.
• Triggers and pushes revision of billings from External Warehousing Partners if actual costs in their billings are incorrect, and far from the planned operational costs.
• Validates with External Logistics Coordinators the services rendered by External Warehouse Partner as indicated in actual billings.
• Links with Accounting for External Warehousing expenses--those with billings already and those for accruals. If actual billings are not yet submitted, prepares Accruals list for Accounting.
• Measures percentage (%) Billing Timeliness of every External Warehouse Partner. If they submit beyond the first week of the following month, formalize warning on their late submission. The 3rd late submission of billings would result to invalid billings already, meaning those would no longer be processed.

4) Governs Overall Inventory and AFS, encompassing TMM and all External Warehouse/ DC sites.

• Checks daily accurate updating of the Overall Inventory and AFS--in SAP and Power BI. Analyzes and audits inventory and AFS patterns in order to detect inconsistencies. For example, the sudden increase of SKUs that were depleted already in the last report.
• Orchestrates with the External Logistics Coordinators and the TMM Team the schedule of the monthly Cycle Count in each Warehouse site. Measures Inventory Accuracy of each site--in SAP, Power BI and physical actual items.
• Pushes closeouts of Near-expiry items, Aging items and On-hold items.
• Strongly works with stakeholders for closeouts.
• Pushes Sales on having a firm Demand Plan for the near-expiry and aging ones.
• Pushes External Logistics Coordinators and TMM Team on having firm actions and timelines on converting on-hold ones to AFS.
• Escalates and publishes a report on these closeouts. Integral part of this report is showing cost simulations along these stagnant items in inventory.
• Measures percentage (%) Closeouts based on agreed actions and timelines with stakeholders.

Food Safety:

• Complies with quality, Halal, health and food safety policy, standards and regulations of the company.
• Responsible for reporting problems related to Halal, food safety & quality management system to identified authorities.

Other Tasks:

• Actively participate in all company programs and activities under quality improvement, safety & security, sustainability, corporate social responsibility, risk management etc.
• Performs other tasks as may be assigned by the team leader.
#J-18808-Ljbffr