Inventory Audit Supervisor

JOB DESCRIPTION

1. Assists and Supervises the Inventory team on their individual tasks

2. Ensures all General Inventory Teams who will perform Store Physical Count are well equipped:

A. Scanner

B. Phone

C. Duly signed and Accomplished Documents to be used per Store including Conforme

3. Audits the schedule prepared by Inventory Team Leader / General Inventory Officer prior to submission to Inventory Audit Manager. This involves

A. Checking of Stock Levels reported by the store

B. Stock Level based on Stock Status Report in MMS. If stock level per MMS is not reconciled with the reported stock level by the store, it should be reported to Inventory Audit Manager.

C. Assignment of proper personnels depending on the specific tasks needed to be performed aside from Physical Count

D. Counterchecking of assignment of members in a team depending on the stock level per store

4. Delivers the results to Inventory Audit Manager subject for audit. When completed, Supervisor shall perform the MMS and Physical Count System (PCouS) Freezing and Posting of Results.

5. Checks the Store Status Report of Inventory Audit Officer and ensures these are updated on a daily basis.

6. Audits the actual count of stores compared to the Book Balance per MMS. Supervisor is expected to use formulae needed to perform audit eg VLOOKUP, Pivot, Concatenate, Subtotal, Conversions, Hyperlink, etc.

7. After posting results, Supervisor must deliver for further audit the Inventory Reports to Inventory Audit Manager on a per store basis after Physical Count. Report must be consisting:

A. PCouS Results

B. MMS Generated Report

C. Stock Variance Analysis Report including Cause and Effect

D. Detailed and Thorough Inventory Audit Findings

E. Attachments to support the findings eg Incident Reports, Photos, and/or Videos extracted from the files sent by Inventory Team Leaders.

REQUIREMENTS

• Graduate of BS in Accountancy or Inventory Management course.
• Must have at least 3 year experience in using MMS.
• Must have a background in audit and reconciliation of stocks and funds.
• Must be good in using Excel, Vlookup, Pivot, Concatenate, Countifs, counterchecking of values, etc.
• Can handle the Audit team members with minimal supervision
• With good communication skills and with sense of urgency