280 likes | 373 Views
Integrating Reagent Selection, Ordering and Inventory Management. Presented at the ACS 219th National Meeting Joint CSA/CINF Symposium: Chemical Information and E-commerce Charles Sullivan, David Evans, Maurizio Bronzetti. March 28, 2000. Evolution. Internet Information.
E N D
Integrating Reagent Selection, Ordering and Inventory Management Presented at the ACS 219th National Meeting Joint CSA/CINF Symposium: Chemical Information and E-commerce Charles Sullivan, David Evans, Maurizio Bronzetti March 28, 2000
Internet Information Company Information Company & Product Information E-commerce E-mail & contact ordering information
What does e-commerce offer? Supply-side Buy-side Cost of doing business Cost of acquisition
Chemical e-commerce sites • Auction sites • bulk chemicals • equipment • Outsourcing/co-op • leverage buying power • Supply-side acquisition
Which one? EDI ERP Bulk chemicals Web Fine chemicals Lab equipment Who?
Workflow Considerations Identify Select Order Receive Pay Dispose/Reorder ERP Inventory Inventory EDI ERP Call ERP Call Fax Online Outsource EDI Catalogs Online Intranet Extranet
Availability Issues COST Availability Medicinal Chemistry HTC Vendors Combinatorial Libraries Hazards HTS
Available Chemicals Directory (ACD) • 906,865 products • 278,093 unique chemicals • 468 unique suppliers • 591 catalogs • Updated semi-annually • Chemical Products Information (CPI) File • Custom Price Loading Tool
Inventory System Characteristics • Registering a chemical • Ability to search the inventory • Tracking the movement of a container • Ability to have multiple containers of the same chemical • Know the type of container • Disposition of a container at the time of disposal
Benefits of an inventory system • Reduced cost of doing business • Satisfy compliance requirements (internal and local, state and federal government) • Provide information that can be used in knowledge management • Increase productivity • Better supply-chain management • Improve safety processes • Save time
Filtering Filtering • Filter on functional groups, elements, sources, cost and packet size or calculated properties
Clustering Clustering • K-Means clustering, using MDL’s 166 Keys
Collect Area • Inventory information is accessible through the collect area
Create Reagent Shopping Lists Create Reagent Shopping Lists
Custom Price Loading Tool • MDL defined ‘staging DB’ format • Custom Price Loading Tool updates a ‘custom price table’ in CPI User defined conversion Utility Custom Price Loading Tool ACD CPI Staging DB Supplier PriceList