Title:  Business Center Analyst - ILOILO Based

PURPOSE OF THE POSITION

• Data Input of Chicken Station sales from supermarkets and distributors in SMSIS (Supermarket Sales Information System) and prescribed excel templates.

• • Supermarket Encoding
  • Database Encoding
  • Sales Order Encoding
  • Provisional Receipt Encoding
  • Merchandise Slip Encoding

SUPERMARKET ENCODING

1. Downloads (from supermarket server) and collates (manually submitted information) supermarket sales of chicken stations & meatshops.
2. Prepares a spreadsheet summary table per material per outlet and per chain with volume, revenue and selling process.
   1. Converts sales quantities into standard KG unit.
   2. Computes for the net revenues and average selling prices from the raw data downloaded from the supermarket systems using a template.
3. Collates and sends via email the following Sales Reports on a per Area, per Chain, per Outlet, and per SKU Level:
   1. Actual bi-monthly sales
   2. Sales accrual for the month
   3. Variance reports
4. Helps Sales Group on the following: (To be confirmed if this will be retained as Prosync’s scope)
   1. Monitoring of daily, weekly and monthly sales for Sales’ accrual report for the preceding month.
   2. Monitoring of timely submission of reports from the Supermarkets.

SALES ORDER ENCODING

1. Receives daily forecast and orders of customers for Poultry and Meats.
2. Collates purchased orders of customers, including house brand and institutional requirements and forwards collated data to responsible plant personnel.
3. Receives summary of allocation of products from the plant.
4. Coordinates with Sales on the final order to be booked.
5. Inputs sales orders for Poultry and Meats in the SAP.
6. Makes order revisions to accommodate changes in orders and allocation plans as directed by Sales.

PROVISIONAL RECEIPT ENCODING

1. Receives the deposit slip from the cashier.
2. Prepares Provisional Receipt (PR).
3. Sends PRs to the scanner thru DAR.
4. Reconciling of billing data versus PRs issued.
5. Updates customer ledgers.
6. Sends a summary report to Sales.

MERCHANDISE SLIP ENCODING

1. Receives the merchandise slips from the Supermarkets.
2. Inputs daily merchandise slips to prescribed sales templates.
3. Prepares a spreadsheet summary table per material per outlet and per chain with volume, revenue and selling process.
   1. Converts sales quantities into standard KG unit.
   2. Computes for the net revenues and average selling prices from the raw data downloaded from the supermarket systems using a template.