|
5.
Process Improvement
5.5. Advanced topics 5.5.3. How do you optimize a process? 5.5.3.2. Multiple response case
|
|||||||||||||||||||||||||||||||||||||||||||
| The mathematical programming approach maximizes or minimizes a primary response, subject to appropriate constraints on all other responses |
The analysis of multiple response systems usually involves some type
of optimization problem. When one response can be chosen as the
"primary", or most important response, and bounds or targets can be
defined on all other responses, a mathematical programming approach
can be taken. If this is not possible, the desirability approach
should be used instead.
In the mathematical programming approach, the primary response is maximized or minimized, as desired, subject to appropriate constraints on all other responses. The case of two responses ("dual" responses) has been studied in detail by some authors and is presented first. Then, the case of more than 2 responses is illustrated. |
||||||||||||||||||||||||||||||||||||||||||
| Dual response systems | |||||||||||||||||||||||||||||||||||||||||||
| Optimization of dual response systems |
The optimization of dual response systems (DRS) consists of finding
operating conditions x that
|
||||||||||||||||||||||||||||||||||||||||||
| Nonlinear programming software required for DRS |
In a DRS, the response models
|
||||||||||||||||||||||||||||||||||||||||||
| More general case | In the more general case of inequality constraints or a cubical region of experimentation, a general purpose nonlinear solver must be used and several starting points should be tried to avoid local optima. This is illustrated in the next section. | ||||||||||||||||||||||||||||||||||||||||||
| Example for more than 2 responses | |||||||||||||||||||||||||||||||||||||||||||
| Example: problem setup |
The values of three components
(x1, x2, x3)
of a propellant need to be selected to maximize a primary response,
burning rate (Y1), subject to satisfactory
levels of two secondary reponses; namely, the variance of the burning
rate (Y2) and the cost
(Y3). The three components must add to 100%
of the mixture. The fitted models are:
|
||||||||||||||||||||||||||||||||||||||||||
| The optimization problem |
The optimization problem is therefore:
|
||||||||||||||||||||||||||||||||||||||||||
| Solve using Excel solver function |
We can use Microsoft Excel's "solver" to solve this problem. The table
below shows an Excel spreadsheet that has been set up with the problem
above. Cells B2:B4 contain the decision variables (cells to be
changed), cell E2 is to be maximized, and all the constraints need to
be entered appropriately. The figure shows the spreadsheet after the
solver completes the optimization. The solution is
(x*)' = (0.212, 0.343, 0.443) which provides
|
||||||||||||||||||||||||||||||||||||||||||
| Excel spreadsheet |
|
||||||||||||||||||||||||||||||||||||||||||