cancherla manu tech_apr08
DESCRIPTION
A peek into "The Power of Data" with specific ref to Supply-chain where lots of data is generated by the minute & Teams are busy fire -fighting every moment !!TRANSCRIPT
![Page 1: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/1.jpg)
Power of Data&
Supply Chain
Ramgopal Cancherla3rd Annual Manufacturing Excellence
Mumbai, INDIAApril 2008
![Page 2: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/2.jpg)
Data Stewards
Database
Data Management
Data Mart
Data Bank
Data Inconsistencies
Data Mining
Data Warehouse
Data Processor
Data Security
Data Recovery
Top of the mind
![Page 3: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/3.jpg)
Topics Overview of Pharma Industry Overview of
Supply chain applications & interfaces
Data Perspectives & Viewpoints
![Page 4: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/4.jpg)
Other EUROPE
USA
Germany
Japan
Spain
ItalyUK
Russia
ITC
Canada
France
Asia-Pacif ic
Worldwide Pharmaceutical Market : 474 EUR Bn. in 2007
Region perimeter : SA Regions
Source : IMS / RMBC MAT Q4-07
USA200 EUR Bn.(42%)
Intercontinental27 EUR Bn. (6%)
Europe (incl. Canada)134 EUR Bn. (28%)
Asia-Pacific & Russia & Japan85 EUR Bn (18%)
Japan : 42 Bn (9%)
Russia : 6 Bn (1%)
Asia-Pacific : 37 Bn (8%)
Asia Pacific- Russia – Japan region : 18% of WW Sales in 2007
France29 EUR Bn. (6%)
![Page 5: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/5.jpg)
Worldwide Pharmaceutical Market : +6% growth vs. last year (value)
Region perimeter : SA Regions
Source : IMS / RMBC MAT Q4-07
Highest growth in Emerging markets.Asia-Pacific 8% of worldwide sales, 14% of worldwide growth
50% of Asia-Pacific growth came from China
+4.1% +4.2%
+6.5% +6.6%
+11.4%
+13.9%
+6.1%
+7.5%
+27,314+1,691+7,855 +1,747 +8,307 +392 +2,770
+4,552
0.0%
2.0%
4.0%
6.0%
8.0%
10.0%
12.0%
14.0%
16.0%
18.0%
20.0%
USA JAPAN WORLD FRANCE EUROPE RUSSIA ITC ASIA-PACIFIC
0
5,000
10,000
15,000
20,000
25,000
30,000
Grth %
Grth ME
![Page 6: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/6.jpg)
Sanofi-aventis key figures
* Definition of consolidated sales and adjusted net income – p 21/22** Data at December 31, 2006
Sanofi-aventis, a leading global pharmaceutical company, discovers,
develops and distributes therapeutic solutions to improve the lives of
everyone.
Sanofi-aventis key figures …• Consolidated sales 2006 * : 28.4 billion euros• Adjusted net income in 2006 * : 7 billion euros (+11.1%)• R&D budget : 4.4 billion euros (+9.5%)• 100,000 employees ** present in nearly 100 Countries
![Page 7: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/7.jpg)
A remarkable medicines portfolio
Central Nervous System
Cardiometabolism
Thrombosis
Oncology
Internal medicine
![Page 8: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/8.jpg)
Suppliers
Manufacturers
Distributors
Retailers
CustomersConsumersThey keep us in Business
![Page 9: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/9.jpg)
Supply chain Applications & Interfaces
Forecasting & Demand Planning - Manugisitcs
ERP – SAP DW – Cognos LRP - Intranet Applications Microsoft Excel
![Page 10: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/10.jpg)
Supply chain Applications & Interfaces
ERP ERP
Forecasting & PlanningSales Heads
Demand
Fulfillment
Sales History (Shipments) Statistical Forecast
Total Sales Forecast
Causal Factors & Events
Total Sales Forecast+= For Local MTS products
Inventory on hand
Independent DemandMRP Calculation
Vehicle Loads (In Transits)
Scheduled Receipts
Inventory on hand
Vehicle Loads (In Transits)
Scheduled Receipts
Planned Orders=
---
Net DemandFor Locally manufactured products
For Local MTO products
Intranet Tool Intranet ToolOrders Planned ArrivalsOr =
Orders
For imported products from Europe
![Page 11: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/11.jpg)
Today’s Situation of Data Existence Plethora of business applications Technology of interfaces Various formats
![Page 12: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/12.jpg)
How Did We Get Here?
Improve productivity thru’ easier access
Eliminate duplicate efforts Prevent poor decisions based on
faulty information Support to Business [cost
avoidance, cost reduction, quality approach, investor confidence]
![Page 13: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/13.jpg)
MastersFoundation of all Applications
TransactionsPurpose of Applications & Business
DataGenerated thru Ongoing Transactions
![Page 15: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/15.jpg)
InformationStructured Data
InterpretationUsage of Structured Data – Evaluation of NEEDS
DecisionEnables Achievement of Immediate, Medium & Long Term Goals
![Page 16: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/16.jpg)
Power of Data
![Page 17: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/17.jpg)
![Page 18: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/18.jpg)
“ Instead of concentrating only on workmen productivity, it is high time that managers & executives concentrate on what they can do by a process of introspection on their role as change agents.”
THE HINDU SPEAKS ON MANAGEMENT
![Page 19: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/19.jpg)
Shift the focus : a Viewpoint
People Involvement& Management
40%
Business Process Knowledge
30%
Product Knowledge
20%
InfrastructureManagement
10%
![Page 20: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/20.jpg)
Paradigm Shift : a viewpoint Independent to Interdependent Functional Excellence to Functional
Integration Internal Competition to
Collaboration Shared vision to excel over
Competition in the Global Market place
![Page 21: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/21.jpg)
Please Do Not…. : a viewpoint
Under estimate the workload Under estimate the stress Discriminate between sources Under estimate the costs
![Page 22: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/22.jpg)
7 6 5 4 3 2 1 0
Total Delivery Time
Total
Costs
Subtly balance costs & service levels
Q1
20%
Q2
40%
Q3
60%
Q4
80%
Q5
100%
![Page 23: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/23.jpg)
![Page 24: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/24.jpg)
INDIA HEALTH INFRASTRUCTURE - 2006
Doctors Nurses Hospitals Hospital Beds PHC Medical Colleges Chemists Medical Reps
6,25,131 8,36,000 17,300 9,14,543 1,63,196 171 5,00,000 3,00,000
![Page 25: Cancherla manu tech_apr08](https://reader035.vdocuments.us/reader035/viewer/2022062511/54bec02a4a7959e91b8b464d/html5/thumbnails/25.jpg)
Power to OUR data in the spirit of
CUSTOMER SERVICE !!
Thank U