vcp implementation at arabian trading supply (al nagy), ksa
TRANSCRIPT
VCP Implementation at Arabian Trading Supply
(Al Nagy), KSA
Background
Number of Employees : 2500+ Number of Users : 15
Arabian Trading Supplies (ATS) was formed from the previous Arabian Food Supplies (AFS) – with dealing in Consumer Products which are conducted under the following divisions:
Consumer Product Division (CPD) MARS Division (MARS)
Cosmetics Division (L’Oreal, Garnier, VICHY) Rickett & Benckiser (RBD)
Food Supplies Division (FSD) ATS is now one of Saudi Arabia's largest marketing and distribution operation. The
company employs over 2,000 people. Its distribution is further enhanced by main large and modern warehouses in Riyadh and
Al Khobar, which in turn supply a network of smaller warehouses strategically located throughout the kingdom.
Project Outline
Modules Implemented
• Oracle Demantra
Demand Management
Operating System : Linux 64-bit Demantra Application & Engine: Windows
Server 2008 R2 Hardware Platform: Linux & Windows (64-
bit)
Integration with Third Party Software: Integration with SAP Business Object
Project Kick Off Date : 4th May 2013
Project Go Live Date :
Resource Details
Evosys Resource Details
Project Manager : 1
Functional Consultant : 3
Technical Consultant : 3
DBA : 5
Client Resource Details
Project Manager(IT) : 1
IT Support : 1
Project Manager (Business) : 1
Business Needs/Problems
Large & Complex Org Structure
Huge Data Volume
11000+ Active Customer Sites
3000+ Active SKU’s
Non Standardized UOM Conversion Definition
Demand Planning & Forecasting at Multiple Levels (Regions, Sales Channel, etc.)
Collaborative Planning (incl. Collaborative Inputs from Sales Team , Marketing
Team, Principal Supplier Team)
Consolidation of Demand Planning Worksheets & Final Monthly Consensus
Forecasts
Challenges
Huge Data Volume & Finalizing Server Sizing
Reducing the Count of Location (Customer Sites) for Demantra
Collecting Multi-Level Data (Locations & Items), enabling Slicing & Dicing Data across
different levels
Defining & Maintaining UOM Conversion in Demantra
Facilitating Demand Planning & Forecasting based on Net Shipment Quantity
Solutions
Reducing the Count of Location Data from 11000+ records to
less than 500 records to be considered for Demantra
Fine tuning the architecture with exactly the required Item &
Location Level & Set of Data, consequently reducing the Server
Sizing requirement.
Collecting the Additional Item & Location Level Data from
Oracle EBS into Demantra for facilitating Demand Planning
across multi-level structure.
Defining Custom Series (columns) for defining Standardize UOM
Conversion, in Demantra.
Defining Custom Series (columns) for Industry Standard KPI
Calculation (MAPE & BIAS)
Custom Program & Custom Columns facilitating Demand Planning
& Forecasting based on the Net Shipment Qty.
Solutions Continued..
Business Benefits Delivered
Flexible Slicing & Dicing of Data across multiple Item & Location Levels
Facilitating Collaborative Planning, Single Window platform for Demand
Planning & Forecast by involving various teams (Sales Team, Principal
Supplier Team, Marketing Team, etc.)
Eliminating Consolidation of Excel Sheet for the Consensus forecast
(Once Source of Data)
Milestones
Achieving Forecast Accuracy of 70%+
Questions?
Thank You Global Headquarter Evolutionary Systems Pvt. Ltd. 11th floor, Kataria Arcade, Beside Adani Vidya Mandir School, Behind ADANI CNG Pump, S. G. Highway, Makarba – Ahmedabad – 380054. Tel : +91 79 30233300, 30233301 Fax : +91 79 30233399,
Follow us on -
ME Headquarter Evolutionary Systems Arabia Fz LLC 112, Building 11, Dubai Internet City, PO Box 500830, Dubai, UAE Board: +9714-4380181 Fax: +9714-4380180
U.K./ Europe Headquarter London Office Evolutionary Systems Company Limited 344-354 Gray’s Inn Road Kings Cross, WC1X 8BP, London Tel :+44 – (0)207-164-2000
Contact Us :
www.evosysglobal.com
http://www.facebook.com/Evosys
http://www.linkedin.com/company/evosys
http://twitter.com/evosysoracle