EMPREGO

Forecast & Artwork Officer (Supply Chain Officer)

6040-BASF Egypt LLC-Cairo, Egypt

The Forecast & Artwork Officer manages and monitors the demand planning and forecasting process of the respective country or affiliate.

That means he/she creates demand forecast (Best case Sales Forecast, accordingly with the integrated planning definition) for the respective country/affiliate according to market developments and supply chain restrictions.

Confirm effective customer order processing, by means of efficient:
1. Order processing

  1. Shipment custom clearance

  2. Warehouse management

  3. Order capture & distribution

  4. Artwork & labels


Key Tasks / Roles & Responsibilities
1. Order processing
Handling Indent MENILE Region countries:

  • Accountable for the creation and maintenance of the sales forecast for all articles of the respective country and for new article requests.
  • Monitor Forecasting KPIs (Forecast Accuracy, etc.) to identify problems and develop solutions to improve future sales forecasts.
  • Accountable for the Outbound sales order for the Local sales until reaching the customer Warehouses.
  • Creates and maintains forecast figures accordingly with the integrated planning process.
  • Ensure “in full on time” orders delivery for the region.
  • Assist in re-organisation the local S&OP process: arranges monthly meetings, prepares those meetings together with the other members of the Forecast Team, prepares aggregated sales forecasts and KPI reports, ensures that market knowledge of marketing and sales teams is incorporated in the forecasting figures.
  • Ensures demand and supply balancing within the local S&OP process.
  • Assures communication with supply chain team in Order Processors for production and supply chain issues.
  • Internal communication with sales & supply chain about the sales & forecast.
  • Communicate with customers to keep them updated with order’s status, in addition of checking all shipping documents needed to release the product.
  • Monitor payments & credit limit in the system as well as assist in solving all problems related to order blockage, embargo or credit in the respective countries.
  • Accountable for the Inbound OTS in the respective countries (Data entry & accuracy).

  • Responsible To handle the situations of non-conformity of products, also reporting data in the non-conformance tool (NCM) for all MENILE countries that means handling NCM regionally.
    2. Shipment custom clearance:

  • Follow up the Bank ID’s for the imported products as well as supervising the clearance process with the forwarder by sending all relevant documents.

  • Following up& aligning with Logistics Coordinator for all requested documents to initiate clearance process.
    3. Warehouse management:

  • Warehouse management: Communicating & managing 3rd party SP to ensure implementation of BASF guidelines for all warehouse management activities including inventory management, stock replenishment, distribution logistics & stock count & quality issues.

  • Handling Shelf-life extension Process: Communicating internally with SC, Registration & Sales teams about confirmed quantitates & aligning with warehouse stickers receipt, quantities & labelling.
  • Handling, preparing & following up all requested documents & +data till process is finalized & stocks are returned to distributors. Ensuring 0 % expired stock.
    4. Order capture & distribution
    Handling Local stock & Outbound management activities
  • Accountable for all transaction type of order processing ensuring in full on time “OTIF” delivery.
  • Following up of orders according to service level and handling all order transactions including creation, delivery, shipment & invoice.
  • Handling & managing all documentation process with warehouse including delivery notes, shipment, expenses & monthly invoices.
  • Checking & following up & sending order invoices with finance team & Customers according to OTC guidelines.
  • Accountable for the Outbound OTS in the respective countries (data entry & accuracy).
  • Responsible To handle the situations of non-conformity of products, also reporting data in the non-conformance tool (NCM) for Egypt that means handling NCM locally.

5. Artwork & Labels:

  • Designing and assuring BASF guidelines over the label aligned with each country’s regulations & in the set timeline in coordination with Global artwork team after technical confirmation from technical department regarding validity versus production windows & ensuring 4-months frozen zone artwork availability.
    Experience and Skills:

  • Good management & communication skills

  • 1-2 years of Experience in Logistics / Supply chain /Customer service
  • Very good English Skills
  • Enthusiastic & eager to learn
  • Proactive and able to work within team
  • Takes ownership and show persistence to achieve results and to exceed expectations
    General responsibilities:
    EHS and Information protection:
    Live and promote "we never compromise on safety". Follow all environment, health and safety related precautions
    Business related information a