An optimization-based decision support system for strategic planning in a process industry: The case of a pharmaceutical company in India

We describe how a generic multi-period optimization-based decision support system (DSS) can be used for strategic planning in process industries. Built on five fundamental elements – materials, facilities, activities, time periods and storage areas – this DSS requires little direct knowledge of optimization techniques to be used effectively. It is user friendly and requires little knowledge of optimization. Results based on real data from a pharmaceuticals company in India demonstrate significant potential for improvements in revenues and profits.

[1]  Miles G. Nicholls,et al.  Aluminum Production Modeling - A Nonlinear Bilevel Programming Approach , 1995, Oper. Res..

[2]  Kin Keung Lai,et al.  A stochastic programming approach for multi-site aggregate production planning , 2006, J. Oper. Res. Soc..

[3]  Robert E. Markland,et al.  Multi-stage lot sizing in a serial production system , 1986 .

[4]  L. J. Walker,et al.  Development and use of a visual interactive planning board within Alcan Aluminium , 1991 .

[5]  Miles G. Nicholls.  Scheduling Production in a Heavily Constrained Plant – Anode Manufacture in an Aluminium Smelter , 1995 .

[6]  Gopal P. Sinha,et al.  A linear programming model for distribution of electrical energy in a steel plant , 1994 .

[7]  Miles G. Nicholls.  Optimizing the Operations of an Ingot Mill in an Aluminium Smelter , 1994 .

[8]  Uday Venkatadri,et al.  Optimization-based decision support for order promising in supply chain networks , 2006 .

[9]  S. Hamamoto.  Development and validation of genetic algorithm-based facility layout a case study in the pharmaceutical industry , 1999 .

[10]  Bernard Grabot,et al.  Decision support for supply chain planning under uncertainty , 2008, Int. J. Syst. Sci..

[11]  Goutam Dutta,et al.  A Survey of Mathematical Programming Applications in Integrated Steel Plants , 2001, Manuf. Serv. Oper. Manag..

[12]  Goutam Dutta,et al.  Database structure for a class of multi-period mathematical programming models , 2007, Decis. Support Syst..

[13]  Robert Fourer,et al.  Database structures for mathematical programming models , 1997, Decis. Support Syst..

[14]  Miles G. Nicholls,et al.  Developing an integrated model of an aluminium smelter incorporating sub-models with different time bases and levels of aggregation , 1997 .

[15]  Jason R. W. Merrick,et al.  The Prince William Sound Risk Assessment , 2002, Interfaces.

[16]  Roy E. Marsten,et al.  The Design of the XMP Linear Programming Library , 1981, TOMS.

[17]  Gopal P. Sinha,et al.  Strategic and Operational Management with Optimization at Tata Steel , 1995 .

[18]  George B. Dantzig,et al.  Linear Programming Under Uncertainty , 2004, Manag. Sci..

[19]  E. Varlan,et al.  Multicriteria decision making for contract research organisation choice in the pharmaceutical industry , 1999, J. Oper. Res. Soc..

[20]  Tan Miller,et al.  Implementing a Distribution-Network Decision-Support System at Pfizer/Warner-Lambert , 2002, Interfaces.

[21]  Tan Miller,et al.  INTEGRATING PRODUCTION AND TRANSPORTATION SCHEDULING DECISIONS BETWEEN TWO GEOGRAPHICALLY SEPARATED PLANTS , 2003 .

[22]  Yadati Narahari,et al.  Queueing network modelling and lead time compression of pharmaceutical drug development , 2001 .

[23]  James R. Evans,et al.  Blending OR/MS, Judgment, and GIS: Restructuring P&G's Supply Chain , 1997 .

[24]  Goutam Dutta,et al.  An Optimization-Based Decision Support System for Strategic and Operational Planning in Process Industries , 2004 .

[25]  C. Tahon,et al.  Production planning knowledge-based system for pharmaceutical manufacturing lines , 1992 .

[26]  Robert Fourer,et al.  Modeling languages versus matrix generators for linear programming , 1983, TOMS.

[27]  Raymond F. Boykin.  Optimizing Chemical Production at Monsanto , 1985 .

[28]  Patrice Loisel,et al.  Effect of Parameter Estimation on Fertilizer Optimization , 1994 .

[29]  K. Jäger,et al.  A decision support system for planning chemical production of active ingredients in a pharmaceutical company , 1989 .

[30]  John R. Birge,et al.  Stochastic Programming Computation and Applications , 1997, INFORMS J. Comput..