Page 138 -
P. 138

118   CHAPTER 3 LINEAR PROGRAMMING: SENSITIVITY ANALYSIS AND INTERPRETATION OF SOLUTION


                                     the problem will provide a maximum profit of $48 450. The optimal values of the
                                     decision variables are given by A ¼ 25, B ¼ 425, C ¼ 150 and D ¼ 0. Thus, the optimal
                                     strategy is to concentrate on agriculture and forestry with B ¼ 425 units. In addition,
                                     the firm should allocate 25 units to the oil rig market (A ¼ 25) and meet its 150-unit
                                     commitment to the national retail chain store (C ¼ 150). With D ¼ 0, the optimal
                                     solution indicates that the firm should not use the Internet market.
                                       Looking at the four constraints, we see that those for advertising, the produc-
                                     tion level and the retail stores requirement are binding. We are using all the
                                     available advertising budget; we are matching the required production level of
                                     600 units in total; and we are meeting the minimum requirement for supplying
                                     retail stores, although for this last constraint there is no surplus either. The
                                     constraint relating to salesforce availability, however, is non-binding and has a
                                     slack value of 25. That is, we do not require all the available salesforce time; 25
                                     hours of the available 1800 hours is unused. Looking now at the sensitivity
                                     information output, we see that for the reduced cost for the four decision variables,
                                     three are zero and one nonzero, that for variable D at 45. Recall that reduced costs
                                     indicate by how much each objective function coefficient would have to change
                                     before the corresponding decision variable took a positive value in the optimal
                                     solution.Fairlyobviously,thefirst threedecision variables,A,B,C,havezero
                                     reduced costs since they are already taking positive values in the solution. For
                                     variable D, however, we see a reduced cost value of 45. Recollect that variable D
                                     indicates the number of radios sold through the Internet. At the optimal solution,
                                     this is set to zero – none of our sales will be through this channel. Effectively, since
                                     we are seeking to maximize profit, we are being told that D is not sufficiently
                                     profitable at $60 per unit, other things being equal. The reduced costs figure of $45
                                     for D tells us how much more profitable D needs to be to take a nonzero value.
                                     Radios sold through the Internet would need to make $105 ($60 + $45) profit per
                                     unit sold to be viable. Let us also look at the other sensitivity information about the
                                     objective function. We can summarize the range of optimality for each of the
                                     objective function coefficients as follows:
                                       A            84   C A   No upper limit
                                       B            50   C b   90
                                       C  No lower limit < C c   87
                                       D   No lower limit < C d   105

                                     So,wesee that thecurrent solutionwill remainoptimalaslongastheobjective
                                     function coefficients remain in the given ranges of optimality. For radios sold to
                                     oil rigs, A, the profit per unit can fall to $84 and A will still remain in the
                                     solution. For radios sold to agriculture and forestry, the profit contribution could
                                     be between $50 and $90 and B remains in the solution. For radios sold through
                                     local distributors, C, there is no lower limit but an upper limit of $87 per unit.
                                     For D, the figures confirm the reduced cost value that we discussed earlier.
                                       Let us now look at the sensitivity information for the four constraints. We already
                                     know that three constraints are binding. Looking at the shadow price for each
                                     constraint and the allowable increase/decrease we can provide the following man-
                                     agement information. The advertising budget of $5000 is all spent at the optimal
                                     solution. The shadow price of $3 indicates that for each extra dollar spent on
                                     advertising over and above the current budget of $5000 total profit will increase by
                                     $3. This will be valid up to an increase of $850. After that we cannot tell from the
                                     sensitivity information what will happen to profit. To do so, we would need to
                                     reformulate and re-solve the problem. Other things being equal, then, management
                                     should give serious consideration to increasing the advertising budget to $5850. Our




                Copyright 2014 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s). Editorial review has
                      deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require it.
   133   134   135   136   137   138   139   140   141   142   143