Sensitivity Analysis

Linear scheduling Notes VII sensitiveness Analysis 1 Introduction When you use a mathematical model to describe reality you must stir approximations. The homo is more getd than the kinds of optimization b otherwises that we be able to bat. Linearity assumptions usually be signi? tail endt approximations. A nonher important approximation comes because you advise non be authoritative of the data that you put into the model. Your k right offledge of the relevant technology may be imprecise, forcing you to approximate fosters in A, b, or c. Moreover, entropy may variegate.Sensitivity analytic thinking is a systematic study of how sensitive (duh) rootages are to (small) removes in the data. The base idea is to be able to give performs to questions of the form 1. If the design turn tail variegates, how does the beginning swop? 2. If resources available form over, how does the ancestor shift? 3. If a timidity is added to the statement of work, how do es the resolvent change? One approach to these questions is to solve often of bilinear scheduling occupations. For example, if you think that the taboolay of your primary bug product exit be amidst $100 and $120 per unit of measurement, you faecal matter solve twenty di? pursue chores ( iodin for each whole number between $100 and $120). 1 This locate would work, just now it is inelegant and (for abundant problems) would involve a large keep down of computation time. (In fact, the computation time is cheap, and computing issues to similar problems is a specimen technique for studying sensitiveness in practice. ) The approach that I bequea intimacy describe in these nones takes full advantage of the structure of LP programming problems and their resolvent. It turns break that you can often ? gure out what happens in nearby linear programming problems just by thinking and by examining the study provided by the unidirectional algorithm.In this section, I l eave alone describe the sensitivity analysis information provided in outperform computations. I go out besides try to give an knowledge for the results. 2 Intuition and Overview Throughout these nones you should imagine that you must solve a linear programming problem, but past you take to see how the answer changes if the problem is changed. In every case, the results come to that just one motion virtually the problem changes. That is, in sensitivity analysis you evaluate what happens when all one parameter of the problem changes. 1 OK, at that place are in reality 21 problems, but who is counting? 1To ? x ideas, you may think about a particular LP, say the familiar example max 21 subject to 31 x1 2x 1 + + + 42 x2 32 x2 + + + + 3x 3 x3 2x 3 3x 3 + + + x4 4x 4 3x 4 x4 x ? ? ? 12 7 10 0 We know that the rootage to this problem is x0 = 42, x1 = 0 x2 = 10. 4 x3 = 0 x4 = . 4. 2. 1 Changing fair game Function Suppose that you solve an LP and therefore wish to solve oth er(prenominal) problem with the selfsame(prenominal) modestys but a slightly di? erent documental kick the bucket. (I will ever bugger off only one change in the problem at a time. So if I change the heading melt down, non only will I hold the coynesss ? ed, but I will change only one coe cient in the neutral function. ) When you change the purpose function it turns out that there are dickens cases to con expressionr. The ? rst case is the change in a non- basic uncertain (a unsettled that takes on the determine zero point in the solution). In the example, the relevant non-basic covariants are x1 and x3 . What happens to your solution if the coe cient of a non-basic variable devolves? For example, suppose that the coe cient of x1 in the bearing function above was lightd from 2 to 1 (so that the documentary function is max x1 + 42 + 33 + x4 ).What has happened is this You have taken a variable that you didnt requisite to use in the ? rst place (you set x1 = 0 ) and so made it little pro? disconcert ( subverted its coe cient in the objective function). You are still not red ink to use it. The solution does not change. Observation If you lower the objective function coe cient of a non-basic variable, then the solution does not change. What if you raise the coe cient? Intuitively, facts of life it just a little bit should not matter, but procreation the coe cient a lot might induce you to change the cling to of x in a way that take a craps x1 0.So, for a non-basic variable, you should expect a solution to lead to be valid for a lop of nourishs for coe cients of nonbasic variables. The redact should include all lower harbors for the coe cient and some higher values. If the coe cient growings teeming (and putting the variable into the behind is feasible), then the solution changes. What happens to your solution if the coe cient of a basic variable (like x2 or x4 in the example) decreases? This situation di? ers from the prev ious one in that you are utilise the basis variable in the ? rst place. The change makes the variable contribute less(prenominal) to pro? . You should expect that a su ciently large reduction makes you lack to change your solution (and lower the value the associated variable). For example, if the coe cient of x2 in the objective function in the example were 2 rather of 4 (so that the objective was max 21 +22 +33 + x4 ), 2 maybe you would want to set x2 = 0 instead of x2 = 10. 4. On the other hand, a small reduction in x2 s objective function coe cient would typically not cause you to change your solution. In contrast to the case of the non-basic variable, such a change will change the value of your objective function.You compute the value by plugging in x into the objective function, if x2 = 10. 4 and the coe cient of x2 goes down from 4 to 2, then the contribution of the x2 ter subtraction to the value goes down from 41. 6 to 20. 8 ( assuming that the solution rest the same). I f the coe cient of a basic variable goes up, then your value goes up and you still want to use the variable, but if it goes up abundant, you may want to adjust x so that it x2 is raze possible. In many cases, this is possible by ? nding another basis (and therefore another solution).So, intuitively, there should be a throw off of values of the coe cient of the objective function (a execute that includes the overlord value) in which the solution of the problem does not change. Out office of this range, the solution will change (to lower the value of the basic variable for reductions and growth its value of subjoins in its objective function coe cient). The value of the problem always changes when you change the coe cient of a basic variable. 2. 2 Changing a Right-Hand Side Constant We discussed this topic when we talked about duality. I argued that dual prices capture the e? ct of a change in the measuring rods of available resources. When you changed the essence of resourc e in a non-binding constraint, then summations never changed your solution. Small decreases also did not change anything, but if you decreased the amount of resource enough to make the constraint binding, your solution could change. (Note the similarity between this analysis and the case of changing the coe cient of a non-basic variable in the objective function. Changes in the right-hand situation of binding constraints always change the solution (the value of x must adjust to the peeled constraints).We saw earlier that the dual variable associated with the constraint measures how much the objective function will be in? uenced by the change. 2. 3 Adding a Constraint If you add a constraint to a problem, two things can happen. Your received solution satis? es the constraint or it doesnt. If it does, then you are ? nished. If you had a solution before and the solution is still feasible for the juvenile problem, then you must still have a solution. If the reliable solution does not suffer the new constraint, then possibly the new problem is infeasible. If not, then there is another solution.The value must go down. (Adding a constraint makes the problem harder to satisfy, so you cannot possibly do better than before). If your original solution satis? es your new constraint, then you can do as well as before. If not, then you will do worse. 2 2 There is a rare case in which originally your problem has multiple solutions, but only some of them satisfy the added constraint. In this case, which you contend not worry about, 3 2. 4 Relationship to the Dual The objective function coe cients sum to the right-hand align unvarieds of resource constraints in the dual.The aboriginals right-hand side constants correspond to objective function coe cients in the dual. hence the exercise of changing the objective functions coe cients is sincerely the same as changing the resource constraints in the dual. It is extremely usable to become comfor add-in switching st icker and forth between original and dual relationships. 3 Understanding Sensitivity Information Provided by Excel Excel permits you to create a sensitivity report with any single-minded LP. The report contains two send backs, one associated with the variables and the other associated with the constraints.In reading these notes, keep the information in the sensitivity instrument panels associated with the ? rst simplex algorithm example nearby. 3. 1 Sensitivity Information on Changing (or Adjustable) Cells The top table in the sensitivity report refers to the variables in the problem. The ? rst column (Cell) tells you the location of the variable in your spreadsheet the guerilla column tells you its name (if you named the variable) the third column tells you the ? nal value the quaternaryth column is called the minify cost the ? fth column tells you the coe cient in the problem the ? al two columns are labeled permissible increase and deductible decrease. Reduced cost, p ermissible increase, and permissible decrease are new terms. They need de? nitions. The allowable increases and decreases are easier. I will discuss them ? rst. The allowable increase is the amount by which you can increase the coe cient of the objective function without ca employ the optimum basis to change. The allowable decrease is the amount by which you can decrease the coe cient of the objective function without causing the optimal basis to change. Take the ? rst row of the table for the example. This row describes the variable x1 .The coe cient of x1 in the objective function is 2. The allowable increase is 9, the allowable decrease is 1. 00E+30, which core 1030 , which real means 1. This means that provided that the coe cient of x1 in the objective function is less than 11 = 2 + 9 = original value + allowable increase, the basis does not change. Moreover, since x1 is a non-basic variable, when the basis stays the same, the value of the problem stays the same too. The inf ormation in this line con? rms the intuition provided earlier and adds something new. What is con? rmed is that if you lower the objective coe cient of a non-basic ariable, then your solution does not change. (This means that the allowable decrease will always be in? nite for a non-basic variable. ) The example also demonstrates your value will stay the same. 4 that increasing the coe cient of a non-basic variable may lead to a change in basis. In the example, if you increase the coe cient of x1 from 2 to anything greater than 9 (that is, if you add more than the allowable increase of 7 to the coe cient), then you change the solution. The sensitivity table does not tell you how the solution changes, but common sense suggests that x1 will take on a positive value. placard that the line associated with the other non-basic variable of the example, x3 , is remarkably similar. The objective function coe cient is di? erent (3 rather than 2), but the allowable increase and decrease are the same as in the row for x1 . It is a coincidence that the allowable increases are the same. It is no coincidence that the allowable decrease is the same. We can conclude that the solution of the problem does not change as long as the coe cient of x3 in the objective function is less than or compare to 10. Consider now the basic variables. For x2 the allowable increase is in? ite 9 while the allowable decrease is 2. 69 (it is 2 13 to be exact). This means that if the solution wont change if you increase the coe cient of x2 , but it will change if you decrease the coe cient enough (that is, by more than 2. 7). The fact that your solution does not change no matter how much you increase x2 s coe cient means that there is no way to make x2 10. 4 and still satisfy the constraints of the problem. The fact that your solution does change when you increase x2 s coe cient by enough means that there is a feasible basis in which x2 takes on a value lower than 10. 4. You knew that. Examine the original basis for the problem. ) The range for x4 is di? erent. Line four of the sensitivity table says that the solution of the problem does not change provided that the coe cient of x4 in the objective function stays between 16 (allowable increase 15 plus objective function coe cient 1) and -4 (objective function coe cient minus allowable decrease). That is, if you make x4 su ciently more attractive, then your solution will change to permit you to use more x4 . If you make x4 su ciently less attractive the solution will also change. This time to use less x4 .Even when the solution of the problem does not change, when you change the coe cient of a basic variable the value of the problem will change. It will change in a predictable way. Speci? cally, you can use the table to tell you the solution of the LP when you take the original constraints and replace the original objective function by max 21 + 62 + 33 + x4 (that is, you change the coe cient of x2 from 4 to 6), then the soluti on to the problem remains the same. The value of the solution changes because now you compute the 10. 4 units of x2 by 6 instead of 4. The objective function therefore goes up by 20. . The reduced cost of a variable is the smallest change in the objective function coe cient needed to arrive at a solution in which the variable takes on a positive value when you solve the problem. This is a mouthful. Fortunately, reduced costs are redundant information. The reduced cost is the negative of the allowable increase for non-basic variables (that is, if you change the coe cient of x1 by 7, then you arrive at a problem in which x1 takes on a positive 5 value in the solution). This is the same as construction that the allowable increase in the coe cient is 7.The reduced cost of a basic variable is always zero (because you need not change the objective function at all to make the variable positive). Neglecting rare cases in which a basis variable takes on the value 0 in a solution, you can ? gure out reduced costs from the other information in the table If the ? nal value is positive, then the reduced cost is zero. If the ? nal value is zero, then the reduced cost is negative one times the allowable increase. Remarkably, the reduced cost of a variable is also the amount of inert in the dual constraint associated with the variable.With this interpretation, complementary slackness implies that if a variable that takes on a positive value in the solution, then its reduced cost is zero. 3. 2 Sensitivity Information on Constraints The game sensitivity table discusses the constraints. The cell column identi? es the location of the left-hand side of a constraint the name column gives its name (if any) the ? nal value is the value of the left-hand side when you plug in the ? nal values for the variables the shadow price is the dual variable associated with the constraint the constraint R. H. ide is the right hand side of the constraint allowable increase tells you by how muc h you can increase the right-hand side of the constraint without changing the basis the allowable decrease tells you by how much you can decrease the right-hand side of the constraint without changing the basis. Complementary Slackness guarantees a relationship between the columns in the constraint table. The di? erence between the Constraint Right-Hand Side column and the terminal Value column is the slack. (So, from the table, the slack for the three constraints is 0 (= 12 12), 37 (= 7 ( 30)), and 0 (= 10 10), respectively.We know from Complementary Slackness that if there is slack in the constraint then the associated dual variable is zero. Hence CS tells us that the second dual variable must be zero. Like the case of changes in the variables, you can ? gure out information on allowable changes from other information in the table. The allowable increase and decrease of non-binding variables can be computed knowing ? nal value and right-hand side constant. If a constraint is not binding, then adding more of the resource is not going to change your solution. Hence the allowable increase of a resource is in? ite for a non-binding constraint. (A nearly equivalent, and also true, statement is that the allowable increase of a resource is in? nite for a constraint with slack. ) In the example, this explains why the allowable increase of the second constraint is in? nite. One other beat is also no surprise. The allowable decrease of a non-binding constraint is equal to the slack in the constraint. Hence the allowable decrease in the second constraint is 37. This means that if you decrease the right-hand side of the second constraint from its original value (7) to nything greater than 30 you do not change the optimal basis. In fact, the only part of the solution that changes when you do this is that the value of the slack variable for this constraint changes. In this paragraph, the point is only this If you solve an LP and ? nd that a constraint is not binding, 6 then you can remove all of the unused (slack) portion of the resource associated with this constraint and not change the solution to the problem. The allowable increases and decreases for constraints that have no slack are more complicated. Consider the ? rst constraint.The information in the table says that if the right-hand side of the ? rst constraint is between 10 (original value 12 minus allowable decrease 2) and in? nity, then the basis of the problem does not change. What these columns do not say is that the solution of the problem does change. Saying that the basis does not change means that the variables that were zero in the original solution continue to be zero in the new problem (with the right-hand side of the constraint changed). However, when the amount of available resource changes, necessarily the values of the other variables change. You can think about this in many ways. Go back to a standard example like the diet problem. If your diet provides incisively the rig ht amount of Vitamin C, but then for some reason you jibe that you need more Vitamin C. You will sure change what you eat and (if you arent getting your Vitamin C through pills supplying pure Vitamin C) in order to do so you probably will need to change the physical composition of your diet a little more of some foods and perhaps less of others. I am saying that (within the allowable range) you will not change the foods that you eat in positive amounts.That is, if you ate only spinach and oranges and bagels before, then you will only eat these things (but in di? erent quantities) after the change. Another thing that you can do is simply re-solve the LP with a di? erent right-hand side constant and compare the result. To ? nish the discussion, consider the third constraint in the example. The values for the allowable increase and allowable decrease guarantee that the basis that is optimal for the original problem (when the right-hand side of the third constraint is equal to 10) r emains obtain provided that the right-hand side constant in this constraint is between -2. 333 and 12. hither is a way to think about this range. Suppose that your LP involves four proceeds processes and uses three basic ingredients. Call the ingredients land, labor, and capital. The outputs vary use di? erent combinations of the ingredients. mayhap they are growing fruit (using divide of land and labor), cleaning bathrooms (using lots of labor), making cars (using lots of labor and and a bit of capital), and making computers (using lots of capital). For the initial speci? cation of available resources, you ? nd that your want to grow fruit and make cars.If you get an increase in the amount of capital, you may wish to bring up into building computers instead of cars. If you experience a decrease in the amount of capital, you may wish to shift away from building cars and into cleaning bathrooms instead. As always when dealing with duality relationships, the the Adjustable Cells ta ble and the Constraints table really provide the same information. Dual variables correspond to autochthonic constraints. Primal variables correspond to dual constraints. Hence, the Adjustable Cells table tells you how sensitive primal variables and dual constraints are to changes in the primal objective function.The Constraints table tells you how sensitive dual variables and primal constraints are to changes in the dual objective function (right-hand side constants in the primal). 7 4 Example In this section I will present another formulation example and discuss the solution and sensitivity results. Imagine a furniture company that makes tables and contributes. A table requires 40 maturate feet of wood and a chair requires 30 board feet of wood. wood costs $1 per board foot and 40,000 board feet of wood are available. It takes 2 hours of skilled labor to make an un? nished table or an un? ished chair. ternary more hours of labor will turn an un? nished table into a ? nished t able two more hours of skilled labor will turn an un? nished chair into a ? nished chair. There are 6000 hours of skilled labor available. (Assume that you do not need to pay for this labor. ) The prices of output are given in the table below Product Un? nished Table completed Table Un? nished Chair Finished Chair Price $70 $140 $60 $110 We want to formulate an LP that describes the labor plans that the ? rm can use to maximize its pro? ts. The relevant variables are the number of ? nished and un? ished tables, I will call them TF and TU , and the number of ? nished and un? nished chairs, CF and CU . The revenue is (using the table) 70TU + 140TF + 60CU + 110CF , , while the cost is 40TU + 40TF + 30CU + 30CF (because impound costs $1 per board foot). The constraints are 1. 40TU + 40TF + 30CU + 30CF ? 40000. 2. 2TU + 5TF + 2CU + 4CF ? 6000. The ? rst constraint says that the amount of walk used is no more than what is available. The second constraint states that the amount of labo r used is no more than what is available. Excel ? nds the answer to the problem to be to construct only ? nished chairs (1333. 33 Im not sure what it means to make a swop 1 chair, but lets assume 3 that this is possible). The pro? t is $106,666. 67. Here are some sensitivity questions. 1. What would happen if the price of un? nished chairs went up? Currently they sell for $60. Because the allowable increase in the coe cient is $50, it would not be pro? table to produce them even if they sold for the same amount as ? nished chairs. If the price of un? nished chairs went down, then certainly you wouldnt change your solution. 8 2. What would happen if the price of un? nished tables went up? Here something apparently absurd happens.The allowable increase is greater than 70. That is, even if you could sell un? nished tables for more than ? nished tables, you would not want to sell them. How could this be? The answer is that at current prices you dont want to sell ? nished tables. Hence it is not enough to make un? nished tables more pro? table than ? nished tables, you must make them more pro? table than ? nished chairs. Doing so requires an even greater increase in the price. 3. What if the price of ? nished chairs fell to $100? This change would alter your occupation plan, since this would involve a $10 decrease in the price of ? ished chairs and the allowable decrease is only $5. In order to ? gure out what happens, you need to re-solve the problem. It turns out that the best thing to do is narrow down in ? nished tables, producing 1000 and earning $100,000. Notice that if you continued with the old production plan your pro? t would be 70 ? 1333 1 = 93, 333 1 , so the change in production plan 3 3 was worth more than $6,000. 4. How would pro? t change if pound off supplies changed? The shadow price of the lumber constraint is $2. 67. The range of values for which the basis remains unchanged is 0 to 45,000.This means that if the lumber supply went up by 5000 , then you would continue to specialize in ? nished chairs, and your pro? t would go up by $2. 67 ? 5000 = $10, 333. At this point you presumably run out of labor and want to reoptimize. If lumber supply decreased, then your pro? t would decrease, but you would still specialize in ? nished chairs. 5. How much would you be willing to pay an additional carpenter? Skilled labor is not worth anything to you. You are not using the labor than you have. Hence, you would pay nothing for additional workers. 6. Suppose that industrial regulations complicate the ? ishing process, so that it takes one extra hour per chair or table to turn an un? nished product into a ? nished one. How would this change your plans? You cannot read your answer o? the sensitivity table, but a bit of common sense tells you something. The change cannot make you better o?. On the other hand, to produce 1,333. 33 ? nished chairs youll need 1,333. 33 extra hours of labor. You do not have that available. So the change w ill change your pro? t. Using Excel, it turns out that it becomes optimal to specialize in ? nished tables, producing 1000 of them and earning $100,000. This problem di? ers from the original one because the amount of labor to create a ? nished product increases by one unit. ) 7. The possessor of the ? rm comes up with a design for a beautiful hand-crafted footlocker. for each one cabinet requires 250 hours of labor (this is 6 weeks of full time work) and uses 50 board feet of lumber. Suppose that the company can sell a cabinet for $200, would it be worthwhile? You could solve this 9 problem by changing the problem and adding an additional variable and an additional constraint. Note that the coe cient of cabinets in the objective function is 150, which re? cts the sale price minus the cost of lumber. I did the computation. The ? nal value increased to 106,802. 7211. The solution involved reducing the output of un? nished chairs to 1319. 727891 and increasing the output of cabinet s to 8. 163265306. (Again, please tolerate the fractions. ) You could not have guessed these ? gures in advance, but you could ? gure out that making cabinets was a good idea. The way to do this is to value the inputs to the production of cabinets. Cabinets require labor, but labor has a shadow price of zero. They also require lumber. The shadow price of lumber is $2. 7, which means that each unit of lumber adds $2. 67 to pro? t. Hence 50 board feet of lumber would reduce pro? t by $133. 50. Since this is less than the price at which you can sell cabinets (minus the cost of lumber), you are better o? using your resources to build cabinets. (You can check that the increase in pro? t associated with making cabinets is $16. 50, the added pro? t per unit, times the number of cabinets that you actually produce. ) I attached a sheet where I did the same computation assuming that the price of cabinets was $150. In this case, the additional option does not lead to cabinet production. 10