NU Industries operates two manufacturing plants that produce three products: Widgets, Gadgets, and Flugels. The finished products are shipped to the Distribution Center for final distribution to the customers. Five periods of production are to be scheduled. According to the Sales Department, the production requirements that must be met due to contracts during the planning horizon are as follows: + Product Period 1 Period 2 Period 3 Period 4 Period 5 Widgets 70 125 185 190 200 Gadgets Flugels 200 300 295 245 240 140 175 205 235 230 Also, the Marketing & Forecasting Department anticipates that NU Industries can cultivate additional demand within the distribution area through effective advertising. The M&F Department projects that each $160 invested in advertising Widgets in a particular period creates additional demand for one Widget in the next period. The corresponding values for Gadgets and Flugels are $120 and $180, respectively. However, the total advertising budget is limited to $70,000 for the entire planning horizon. Throughout the planning horizon, NU Industries will sell Widgets for $2490, Gadgets for $1990, and Flugels for $2970. The products can be manufactured at either of NU's Manufacturing Plants. The Engineering Department has provided the following manufacturing and inventory data. Plant A The production requirements at Plant A are summarized below. Each Widget requires 194 pounds of Raw Material 1, 8.6 pounds of Raw Material 2, and 9.5 hours of Labor. Each Gadget requires 230 pounds of Raw Material 1 and 7.1 hours of Labor. Each Elugel requires 178 pounds of Raw Material 1, 11.6 pounds of Raw Material 2, and 11.1 hours of Labor. Regular time labor availability is limited to 2500 hours in each period, but overtime can be scheduled in any amount if necessary. Labor costs during periods 1 and 2 are $11/hour for regular time and $16.50/hour for overtime. Labor costs are expected to rise by 5% at the end of period 2. The product inventory area can store a combined maximum of 70 units, and inventory costs are as follows. It costs $7.50 to store one Widget from one period to the next. The corresponding costs for Gadgets and Flugels are $5.50 and $6.50, respectively. Plant B The production requirements at Plant B are summarized below. Plant B is the more modern of the two facilities and is able to produce the products in a slightly more efficient manner. Each Widget requires 188 pounds of Raw Material 1, 9.2 pounds of Raw Material 2, and 9.1 hours of Labor. Each Gadget requires 225 pounds of Raw Material 1 and 7.8 hours of Labor. Each Flugel requires 170 pounds of Raw Material 1, 10.8 pounds of Raw Material 2, and 10.6 hours of Labor. Regular time labor availability is limited to 3800 hours in each period, but overtime can be scheduled in any amount if necessary. Labor costs during periods 1 and 2 are $11/hour for regular time and $16.50/hour for overtime. Labor costs are expected to rise by 10% at the end of period 2. The product inventory area can store a combined maximum of 50 units, and inventory costs are as follows. It costs $7.80 to store one Widget from one period to the next. The corresponding costs for Gadgets and Flugels are $5.70 and $7.00, respectively. Raw Material A maximum of 70 tons of Raw Material 1 and 2.5 tons of Raw Material 2 are available from a raw material vendor each period. Because of the proximity of the vendor to the plants, Raw Material 1 delivered to Plant A costs $1.25/pound and Raw Material 2 delivered to Plant A costs $2.65/pound. The corresponding costs for Plant B are $1.45/pound for Raw Material 1 and $2.90/pound for Raw Material 2. Each plant only purchases raw material that can be used within a given period, since storage areas are limited. (Note, 1 ton = 2000 pounds) Transportation Costs There is an average transportation cost associated with the shipment of each unit of finished product from each plant to the Distribution Center. The cost depends on the product and the plant of origin. The unit shipping costs are given in the following table. + Product Plant A Plant B Widgets $6.30 $6.50 Gadgets $4.60 $5.00 Flugels $5.50 $5.70 Demand in a given period must be satisfied by utilizing the units produced in that period or by using inventory from a previous period. The problem is to determine the marketing, production, distribution, inventory strategy that maximizes profit. Assume that there is no inventory at the start of the first period and there should be no inventory at the end of the planning horizon. All other plant overhead is assumed to be constant and can be ignored for this analysis. Also, ignore integer restrictions; that is, assume that fractional units can be manufactured, stored, etc. (For reporting purposes, you can round everything off to the nearest tenth.) Once solving for the baseline case. Do a complete sensitivity analysis, and make business recommendations. For example, if you could increase advertising budget - how much? Which raw material do you need more of? Recreate these scenarios and provide profit considerations. Also, if you solved this problem as an integer problem, how much does that differ your recommendations (above). 1234567820-23156722222222222233 3 3 3 3 3 3 1 GLPK 4.65 SENSITIVITY ANALYSIS REPORT 3 Problem: 4 Objective: OBJ = -267969.2324 (MAXimum) Page 1 No. Row name St Activity Slack Marginal Lower bound Upper bound Activity range Obj coef Obj value at Limiting range break point variable 9 1 C1 NS 70.00000 70.00000 35.26316 -405.88000 70.00000 231.52689 -Inf -253870.24289 C112 +Inf -333529.76817 _C75 2 C10 NS 190.00000 190.00000 190.00000 -436.17750 190.00000 534.46428 3 C100 BS 35.26316 -35.26316 +Inf 35.26316 50.00000 -Inf -267969.23237 C56 +Inf -418216.79938 _C83 -13.03159 -268428.76750 C102 21.03500 -267227.47184 S1GPA 4_C101 BS 200.00000 -200.00000 19 5 C102 NL +Inf 156.00000 200.00000 -18.93158 -271755.54816 P1GPB 16.96001 -264577.22948 S1GPB -29.16198 -13.03159 +Inf 6 _C103 BS 55.00000 -55.00000 +Inf 55.00000 84.16198 7 C104 BS 300.00000 -300.00000 +Inf 230.00000 343.74297 29 8 _C105 BS +Inf -70.00000 29.16198 32 33 9 C106 BS 30.26316 -30.26316 30.26316 34 +Inf 64.23205 -Inf -267589.20534 04PA 13.03159 -267969.23237 S1FPA -6.53750 268328.79487 C115 2.49567 -267831.97053 P1FPA -4.42842 -269297.75868 S1GPA 115.57560 -233296.55105 Mf1G -7.63750 -267969.23237 S2FPA 6.47841 -267969.23237 P2FPA -.88667-267996.06570 S3GPB -267969.23237 03PA 35 36 10 C107 BS 295.00000 -295.00000 37 +Inf 225.00000 295.00000 -1.35000 -268367.48237 S2GPA .70000 -267762.73237 S3GPB 20 38 39 GLPK 4.65 SENSITIVITY ANALYSIS REPORT 40 40 41 Problem: Page 2 42 Objective: OBJ = -267969.2324 (MAXimum) 43 44 No. Row name St Activity 45 Slack Marginal Lower bound Upper bound Activity range 46 47 11 _C108 BS 48 +Inf -70.00000 25.90090 Obj coef Obj value at Limiting range break point variable -1.00000 -267969.23237 S3FPA 15.63591 -267969.23237 P3FPA 49 50 12 C109 BS 86.72129 -86.72129 51 +Inf 86.72129 109.75837 -267969.23237 _C59 1.30000 -267856.49469 S4WPB 52 53 13 C11 NS 245.00000 54 -422.03750 245.00000 245.00000 245.00000 535.54813 -Inf -267969.23237 _C57 +Inf -390591.43834 _C83 55 56 14 _C110 BS 245.00000 -245.00000 57 +Inf 245.00000 245.00000 58 59 15 _C111 BS 60 +Inf -34.82677 39.55423 61 62 16 _C112 BS 34.73684 -34.73684 63 +Inf 20.00000 34.73684 64 65 17 C113 BS -44.66667 66 +Inf 44.00000 -.70000 -268140.73237 S3GPB .70000 -267797.73237 S4GPB -1.00000 -267969.23237 S4FPA 15.63591 -267969.23237 P4FPA -21.03500 -268699.92184 S1GPA 13.03159 -267516.55596 _C102 -16.96001-267969.23237 S1GPB 18.93158 -267969.23237 P1GPB 67 68 18 _C114 BS 140.00000 -140.00000 69 +Inf 140.00000 140.00000 -13.03159 -269793.65544 C102 +Inf +Inf 70 71 19 _C115 NL -33.96890 72 -6.53750 +Inf 73 74 20 C116 NL -43.02727 75 -5.48750 +Inf -Inf -267747.16071 04PA 6.53750 -267969.23237 S2WPB -Inf -267733.12023 04PA 5.48750 -267969.23237 C51 76 77 GLPK 4.65 SENSITIVITY ANALYSIS REPORT 78 79 Problem: Page 3 80 Objective: OBJ = -267969.2324 (MAXimum) 81 82 No. Row name St Activity 83 Slack Marginal Lower bound Upper bound Activity range range 84 85 21 _C117 BS 358.49057 -358.49057 86 +Inf 308.49057 387.65254 87 88 22 C118 BS 84.73684 -84.73684 89 +Inf 50.76795 84.73684 90 91 23 C119 BS 92 +Inf -38.33333 107.33333 93 94 24 _C12 NS 235.00000 235.00000 95 -435.41159 235.00000 235.00000 304.65354 96 97 25 C120 BS 285.74479 -285.74479 98 +Inf 285.74479 314.90676 ' 99 100 26 _C121 BS 103.27871 -103.27871 101 +Inf 80.24163 103.27871 102 103 27 C122 BS -29.18030 104 +Inf Obj coef Obj value at Limiting break point variable -1.30000 -268435.27010 S2FPB 23.00841 -259720.93566 02PB -267969.23237 03PA .88667-267894.09903 S3GPB -.70000 -267969.23237 S3GPB 20.98179 -267969.23237 P3GPB -Inf -267969.23237 _C58 +Inf -298297.18962 Mf3F -1.03282 -268264.35544 S3GPB -267969.23237 03PA -1.30000 -268103.49469 S4WPB -267969.23237 _C59 -.70000 -267969.23237 S4GPB 20.98179 -267969.23237 P4GPB 105 106 28 C123 BS 269.82677 -269.82677 107 +Inf 269.82677 269.82677 -267969.23237 _C59 2.06564 -267411.86712 S3GPB 108 109 29 C13 NS 200.00000 200.00000 200.00000 110 -436.17750 200.00000 292.78324 111 S 112 30 C14 NS 240.00000 240.00000 113 -422.03750 240.00000 240.00000 527.11335 -Inf -267969.23237 C61 +Inf -308439.19410 Mf4F -Inf -267969.23237 _C60 +Inf-389141.83128 C84 114 115 GLPK 4.65 SENSITIVITY ANALYSIS REPORT 116 117 Problem: Page NL 200.00000 118 Objective: OBJ = -267969.2324 (MAXimum) 119 120 No. Row name St Activity 121 122 123 31 _C15 124 NS 230.00000 -435.41159 125 126 32 C16 NL 127 -1.25000 128 129 33 C17 = 130 131 132 34 _C18 NL 133 134 135 35 C19 NL 136 137 138 36 _C2 NS st 139 140 141 37 _C20 NL -1075.00000 142 -2.65000 +Inf 3925.00000 143 144 38 _C21 NL 145 -16.50000 +Inf -937.50000 +Inf 146 147 39 _C22 NL 148 -1.25000 +Inf -73721.05263 66278.94737 149 150 40 C23 NL 151 -2.65000 +Inf -260.26316 4739.73684 Slack Marginal Lower bound Upper bound Activity range 230.00000 230.00000 230.00000 309.65354 +Inf -66421.05263 73578.94737 Obj coef Obj value at Limiting break point variable range -Inf -267969.23237 061 +Inf -302651.30555 Mf4F -Inf -184942.91658 R1P1PA 1.25000 -359942.91658 _C80 -2.65000 +Inf -905.26316 4094.73684 -Inf-265570.28500 R2P1PA 2.65000 -278820.28500 C90 -14.13579 +Inf -330.00000 335.00000 -1.25000 +Inf -93250.00000 46750.00000 -398.11842 200.00000 200.00000 200.00000 244.66667 -Inf -263304.42184 C112 14.13579-272704.72184 _C100 -Inf -151406.73237 R1P2PA 1.25000 -326406.73237 C81 -Inf -267969.23237 C48 +Inf -285751.85517 C100 -Inf-265120.48237 R2P2PA 2.65000 -278370.48237 _C91 -Inf -252500.48237 02PA 16.50000 -Inf -Inf -175817.91658 R1P3PA 1.25000 -350817.91658 _C82 -Inf -267279.53500 R2P3PA 2.65000 -280529.53500 C92 152 153 GLPK 4.65 - SENSITIVITY ANALYSIS REPORT 154 155 Problem: Page 156 Objective: OBJ = -267969.2324 (MAXimum) 157 158 No. Row name St Activity 159 Slack Marginal Lower bound Upper bound Activity range 160 161 41 _C24 NL 162 -17.32500 +Inf -322.70452 287.50000 163 164 42 C25 NL 165 -1.25000 +Inf -73173.93034 66826.06966 166 167 43 C26 NL 168 -2.65000 +Inf -745.80310 4254.19690 169 170 44 _C27 NL -161.35226 171 -17.32500 +Inf +Inf 172 173 45 C28 NL 174 -1.25000 +Inf -73963.93034 66036.06966 175 176 46 _C29 NL 177 -2.65000 +Inf -831.80310 4168.19690 178 179 47 _C3 NS St 140.00000 180 -400.12000 140.00000 140.00000 90.00000 278.66931 Obj coef Obj value at Limiting range break point variable -Inf -262378.37660 04PA 17.32500 -272950.16987 C106 -Inf -176501.81944 R1P4PA 1.25000 -351501.81944 _C83 -Inf-265992.85416 R2P4PA 2.65000 -279242.85416 _C93 -Inf-265173.80448 04PA 17.32500 -Inf -175514.31944 R1P5PA 1.25000 -350514.31944 _C84 -Inf-265764.95416 R2P5PA 2.65000 -279014.95416 _C94 -Inf -247963.23237 C49 +Inf -323453.59860 C75 -Inf 181 182 48_C30 NL -218.85226 183 -17.32500 +Inf +Inf -Inf -264177.61698 05PA 17.32500 -Inf 184 185 49 _C31 NL 186 -1.45000 +Inf -38830.52632 101169.47368 187 188 50 C32 NL 189 -2.90000 +Inf -2371.57895 2628.42105 -Inf -211664.96921 R1P1PB 1.45000 -414664.96921 _C85 -Inf -261091.65342 R2P1PB 2.90000 -275591.65342 _C95 UT 5 191 GLPK 4.65 SENSITIVITY ANALYSIS REPORT 192 193 Problem: 194 Objective: OBJ = -267969.2324 (MAXimum) 195 196 No. Row name St Activity 197 Slack Marginal Lower bound Upper bound Activity range 198 199 51 _C33 NL 200 -11.00000 +Inf -2330.10526 1469.89474 201 202 52_C34 NL 203 -1.4 -1.45000 +Inf -60943.39623 79056.60377 204 205 53 C35 = NL 206 -2.90000 +Inf -3871.69811 1128.30189 207 208 54 _C36 NL 209 -14.32940 +Inf -309.11696 1879.67251 210 211 55_C37 NL 212 -1.45000 +Inf -64507.14002 75492.85998 213 214 56 _C38 NL 215 -2.90000 +Inf -3865.62264 1134.37736 216 217 57 _C39 NL 218 -14.32940 +Inf -309.11696 855.89474 219 S 220 58 _C4 NS 125.00000 125.00000 221 -428.34000 125.00000 70.00000 365.97938 222 223 59 _C40 NL 224 -1.45000 +Inf -65286.94799 74713.05201 225 226 60 _C41 NL -3864.29322 227 -2.90000 +Inf 1135.70678 228 Page 6 Obj coef Obj value at Limiting break point variable range -Inf -242338.07447 R1PB 11.00000 -284138.07447 _C75 -Inf -179601.30784 R1P2PB 1.45000 -382601.30784 _C86 -Inf -256741.30784 R2P2PB 2.90000 -271241.30784 _C96 -Inf -263539.77317 04PA 14.32940 -294903.80344 C121 -Inf -174433.87934 R1P3PB 1.45000 -377433.87934 _C87 -Inf -256758.92671 R2P3PB 2.90000 -271258.92671 _C97 -Inf -263539.77317 04PA 14.32940 -280233.68665 Mf2F -Inf -244410.53237 C103 +Inf -371190.34061 C81 -Inf -173303.15778 R1P4PB 1.45000 -376303.15778 _C88 -Inf -256762.78202 R2P4PB 2.90000 -271262.78202 _C98 228 229 GLPK 4.65 SENSITIVITY ANALYSIS REPORT 230 231 Problem: Page 7 232 Objective: OBJ = -267969.2324 (MAXimum) 233 234 No. Row name St Activity 235 236 237 61 _C42 NL 238 -14.32940 239 240 62 _C43 NL 241 242 243 63 _C44 NL 244 Slack Marginal Lower bound Upper bound Activity range -309.11696 +Inf -1.45000 +Inf -65286.94799 74713.05201 -2.9 -2.90000 +Inf -3864.29322 1135.70678 245 246 64 _C45 NL 247 -14.32940 +Inf 844.32749 Obj coef Obj value at Limiting range break point variable -Inf -263539.77317 04PA 14.32940-267969.23237 _061 -Inf -173303.15778 R1P5PB 1.45000 -376303.15778 _C89 -Inf -256762.78202 R2P5PB 2.90000 -271262.78202 _099 -Inf -267969.23237 C61 14.32940 -280067.93492 Mf4F 248 249 65 _C46 NU 70000.00000 -Inf 250 13.08105 70000.00000 64750.84409 101918.96723 -13.08105 -336633.68596 04PA +Inf 149564.26868 _C121 251 252 66 _C47 BS 140.00000 -70.00000 253 70.00000 +Inf 110.83802 190.00000 -2.49567 -268318.62613 P1FPA 12.83159 -266172.80929 S1WPB 254 255 67 _C48 BS 200.00000 256 200.00000 +Inf 200.00000 270.00000 -Inf 4.42842 -267083.54816 S1GPA -Inf 257 258 68 _C49 BS 190.00000 -50.00000 259 140.00000 +Inf 140.00000 219.16198 -12.83159 -270407.23511 S1WPB 2.49567-267495.05511 P1FPA 260 261 69 _C5 NS 300.00000 300.00000 300.00000 262 -415.85000 300.00000 503.26087 263 264 70 _C50 BS 195.00000 -70.00000 125.00000 125.00000 265 +Inf 245.00000 -Inf -267969.23237 C51 +Inf-352495.26498 C81 -1.35000 -268232.48237 S2GPA 1.30000 -267715.73237 P2WPB 267 GLPK 4.65 - SENSITIVITY ANALYSIS REPORT 268 269 Problem: Page 8 270 Objective: OBJ = -267969.2324 (MAXimum) 271 272 No. Row name St Activity Slack 273 Marginal Lower bound Upper bound Activity range range 274 275 71 _C51 BS 300.00000 276 300.00000 +Inf 300.00000 370.00000 Obj coef Obj value at Limiting break point variable -5.48750 -269615.48237 C116 1.35000 -267564.23237 S2GPA 277 278 72 _C52 BS 175.00000 279 175.00000 +Inf 175.00000 225.00000 -Inf 1.30000 -267741.73237 S2FPB -Inf 280 281 73 _C53 BS 185.00000 282 185.00000 +Inf 185.00000 215.26316 -Inf 1.20000 -267747.23237 S3WPA -Inf 283 284 74 _C54 BS 295.00000 285 295.00000 +Inf 295.00000 -Inf -Inf 295.00000 .70000 -267762.73237 S3GPB 286 287 75 C55 BS 205.00000 288 205.00000 +Inf 205.00000 205.00000 -Inf 1.00000 -267764.23237 S3FPA -Inf 289 290 76 _C56 BS 190.00000 291 190.00000 +Inf 190.00000 213.03708 -Inf 1.20000 -267741.23237 S4WPA -Inf 292 293 77 _C57 BS 245.00000 294 245.00000 +Inf 245.00000 245.00000 -Inf .70000 -267797.73237 S4GPB -Inf 295 296 78 _C58 BS 235.00000 297 235.00000 +Inf 235.00000 235.00000 -Inf -Inf 1.00000 -267734.23237 S4FPA 298 299 79 _059 NL 200.00000 300 200.00000 +Inf 153.92584 200.00000 301 302 80 C6 NS ST 175.00000 175.00000 303 -435.41159 175.00000 175.00000 352.32760 -Inf -267969.23237 05PA -267969.23237 _C61 -Inf -267969.23237 _C52 +Inf -345179.72337 C121 305 GLPK 4.65 SENSITIVITY ANALYSIS REPORT 306 307 Problem: Page 9 308 Objective: OBJ = -267969.2324 (MAXimum) 309 310 No. Row name St Activity Slack 311 Marginal Lower bound Upper bound Activity range range 312 313 81 _C60 BS 240.00000 314 240.00000 +Inf 176.16809 240.00000 Obj coef Obj value at Limiting break point variable -20.98179 -273004.86094 P5GPB 20.98179 -262933.60380 P4GPB 315 316 82 _061 BS 230.00000 317 230.00000 +Inf 200.83802 309.65354 -267969.23237 _C59 23.63159 -262533.96588 _C79 318 319 83 C62 NU NU 70.00000 320 21.26000 -Inf 70.00000 35.26316 105.26316 -21.26000 -268707.73763 C112 +Inf -267219.53763 C100 321 322 84 _C63 NU 70.00000 323 6.63750 -Inf 70.00000 103.96890 -6.63750 -268433.85737 S2WPA +Inf -267743.76382 04PA 324 325 85 _C64 BS 70.00000 326 -Inf 70.00000 38.33333 327 328 86 _C65 BS 70.00000 329 -Inf 70.00000 29.18030 -Inf -267969.23237 .90000 -267969.23237 S3GPA -Inf -267969.23237 .90000 -267969.23237 S4GPA 330 331 87 _C66 NU 50.00000 332 33.99159 -Inf 50.00000 79.16198 -33.99159 -269668.81204 S1FPB +Inf -266977.97029 04PA 333 334 88 _C67 BS 50.00000 335 -Inf 50.00000 84.73684 336 337 89 _C68 BS 50.00000 338 -Inf 50.00000 339 340 90_C69 BS 50.00000 341 -Inf 50.00000 -5.48750 -267969.23237 C116 1.30000 -267969.23237 P2WPB -Inf -267969.23237 .70000 -267969.23237 S3GPB -Inf -267969.23237 .70000 -267969.23237 S4GPB 342 343 GLPK 4.65 SENSITIVITY ANALYSIS REPORT 344 345 Problem: Page 10 346 Objective: OBJ = -267969.2324 (MAXimum) 347 348 No. Row name St Activity Slack Lower bound 349 Marginal Upper bound Activity range range 350 351 91 _C7 NS 185.00000 185.00000 352 -436.17750 185.00000 185.00000 279.05437 Obj coef Obj value at Limiting break point variable -Inf -267969.23237 C53 +Inf -308993.63089 Mf2F 353 354 92 _C70 NU 2500.00000 355 3.13579 -Inf 2500.00000 2165.00000 2830.00000 -3.13579 -269019.72184 C100 +Inf -266934.42184 C112 356 357 93 C71 NU 2500.00000 358 5.50000 -Inf 2500.00000 3437.50000 359 360 94 _C72 NU NU 2500.00000 361 5.77500 -Inf 2500.00000 2212.50000 2822.70452 -5.50000 -281719.23237 R2PA +Inf -262812.98237 02PA -5.77500 -269629.54487 C106 +Inf -266105.61378 04PA 362 363 95 _C73 NU 2500.00000 -Inf 364 5.77500 2500.00000 2661.35226 -5.77500 -282406.73237 R4PA +Inf -267037.42307 04PA 365 366 96 _C74 NU 2500.00000 367 5.77500 -Inf 2500.00000 2718.85226 -5.77500 282406.73237 R5PA +Inf -266705.36057 05PA 368 369 97 C75 BS 2330.10526 1469.89474 370 -Inf 3800.00000 2196.00000 2374.79983 371 372 98 _C76 NU 3800.00000 373 3.32940 -Inf 3800.00000 1920.32749 4109.11696 374 375 99 _C77 NU 3800.00000 376 2.22940 -Inf 3800.00000 2944.10526 4109.11696 377 378 100 C78 NU 3800.00000 379 2.22940 -Inf 3800.00000 3800.00000 4109.11696 -2.31154 -273355.36030 S1GPA 1.62836-264174.99160 P1FPA -3.32940-274227.40577 C121 +Inf -266940.05972 04PA -2.22940 -269877.36033 Mf2F +Inf -267280.08838 04PA -2.22940 -267969.23237 _C61 +Inf -267280.08838 04PA 380 381 GLPK 4.65 SENSITIVITY ANALYSIS REPORT 382 383 Problem: Page 11 384 Objective: OBJ = -267969.2324 (MAXimum) 385 386 No. Row name St Activity 387 Slack Marginal Lower bound Upper bound Activity range 388 389 101 C79 NU 3800.00000 -Inf 390 2.22940 3800.00000 2955.67251 3800.00000 391 392 102 C8 NS 295.00000 393 -422.03750 295.00000 295.00000 295.00000 333.33333 394 395 103 C80 BS 66421.05263 73578.94737 -Inf 396 140000.00000 65001.63176 71800.00000 397 398 104 _C81 BS 93250.00000 46750.00000 -Inf 399 140000.00000 93250.00000 98907.42359 400 401 105 C82 BS 73721.05263 66278.94737 -Inf 68342.10526 402 140000.00000 80311.01857 403 404 106 C83 BS 73173.93034 66826.06966 -Inf 73173.93034 405 140000.00000 73173.93034 406 407 107 _C84 BS 73963.93034 66036.06966 -Inf 70668.94737 408 140000.00000 73963.93034 Obj coef Obj value at Limiting range break point variable -2.22940 -269851.57235 Mf4F +Inf-267969.23237 _C61 -Inf -267969.23237 C54 +Inf -284147.33653 C106 -.05127 -271374.87167 P1FPA .05763 -264141.37801 S1GPA -.02386 -270194.05574 C116 .01286 -266769.63853 P1FPA -.01757-269264.40018 S2GPA -267969.23237 03PA -267969.23237 _C59 .00304 -267746.52910 S4GPB -267969.23237 03PA -267969.23237 _C59 409 410 108 _C85 BS 38830.52632 101169.47368 -Inf 411 140000.00000 36060.00000 39753.88661 -.11189 -272313.91386 S1GPA .07882 -264908.63524 P1FPA 412 413 109 _C86 BS 60943.39623 79056.60377 -Inf 414 140000.00000 30797.70495 63046.22642 -.20760-280620.93566 C76 .03091 -266085.42797 P2WPB 415 416 110 C87 BS 64507.14002 75492.85998 -Inf 417 140000.00000 63078.52359 64507.14002 -267969.23237 03PA .02108 -266609.24783 S3GPB 419 GLPK 4.65 420 421 Problem: - SENSITIVITY ANALYSIS REPORT Page 12 422 Objective: OBJ = -267969.2324 (MAXimum) 423 424 No. Row name St Activity 425 Slack Marginal Lower bound Upper bound Activity range range 426 427 111 _C88 BS 65286.94799 74713.05201 -Inf 428 140000.00000 65286.94799 65286.94799 Obj coef Obj value at Limiting break point variable -.04217 -270722.08235 S3GPB -267969.23237 _C59 429 430 112 C89 BS 65286.94799 74713.05201 -Inf 431 140000.00000 65286.94799 66001.25621 432 433 113 C9 NS 205.00000 434 -435.41159 205.00000 205.00000 205.00000 285.74479 435 436 114 _C90 BS 905.26316 4094.73684 -Inf 437 5000.00000 430.00000 950.51027 -267969.23237 _C59 -267969.23237 03PA -Inf -267969.23237 _C55 +Inf -303126.44851 Mf2F -.65225-268559.68851 S1GPA 1.60847-266513.14282 P1FPA 438 439 115 C91 BS 1075.00000 3925.00000 440 -Inf 5000.00000 473.00000 1325.79300 -.15698 -268137.98237 S2GPA .29019 -267657.27365 P1FPA 441 442 116 C92 BS 260.26316 4739.73684 -Inf 443 5000.00000 260.26316 552.39567 -.10310-267996.06570 S3GPB -267969.23237 03PA 444 445 117 C93 BS 745.80310 4254.19690 446 -Inf 5000.00000 745.80310 943.92198 -267969.23237 _C59 .13953 -267865.16682 S4WPA 447 448 118 _C94 BS 831.80310 4168.19690 -Inf 449 5000.00000 685.73684 831.80310 -267969.23237 03PA -267969.23237 _C59 450 451 119 C95 BS 2371.57895 2628.42105 452 -Inf 5000.00000 2236.00000 2416.76466 -2.28641 -273391.64141 S1GPA 1.61066 -264149.43349 P1FPA 453 454 120 C96 BS 3871.69811 1128.30189 455 -Inf 5000.00000 3474.33962 4186.64747 -2.72824 -278532.15361 P2GPB 2.13041 -259720.93566 02PB 550 GLPK 4.65 SENSITIVITY ANALYSIS REPORT 551 552 Problem: Page 16 553 Objective: OBJ = -267969.2324 (MAXimum) 554 555 No. Column name St Activity 556 Obj coef Marginal Lower bound Upper bound Activity range range 557 558 21 05PA BS 218.85226 -17.32500 559 +Inf 57.50000 218.85226 560 561 22 05PB NL -18.15000 -844.32749 562 -3.82060 +Inf 563 564 23 P1FPA NL -5.50000 565 -2.49567 +Inf 29.16198 Obj coef Obj value at Limiting break point variable -17.32500 -267969.23237 03PA -17.32500 -267969.23237 _C59 -Inf -264743.39107 Mf4F -14.32940-267969.23237 _061 -Inf -267969.23237 S1FPA -3.00433 -268042.01103 04PA 566 567 24 P1FPB BS 190.00000 -5.70000 568 +Inf 140.00000 190.00000 -18.53159 -270407.23511 S1WPB +Inf +Inf 569 570 25 P1GPA BS 200.00000 -4.60000 571 +Inf 156.00000 270.00000 -23.53158 -271755.54816 P1GPB -.17158 -267083.54816 S1GPA 572 573 26 P1GPB NL -5.00000 574 -18.93158 +Inf 44.00000 -Inf -267969.23237 C113 13.93158 -268802.22184 _C112 575 576 27 P1WPA BS 105.26316 -6.30000 577 +Inf 71.18969 140.00000 -8.43593 -268194.06748 P1FPA 16.16000-265605.02184 01PA 578 579 28 P1WPB BS 34.73684 -6.50000 580 +Inf 20.00000 84.73684 -27.53500 -268699.92184 S1GPA 6.33159 -267523.50333 S1WPB 581 582 29 P2FPA NL -5.50000 583 -6.47841 +Inf 29.16198 -Inf -267969.23237 C105 .97841 -268158.15551 04PA 584 585 30 P2FPB BS 358.49057 -5.70000 586 +Inf 315.56604 387.65254 -7.21429 -268512.08951 P2WPB 17.30841 -259720.93566 02PB 587 588 GLPK 4.65 SENSITIVITY ANALYSIS REPORT 589 590 Problem: 591 Objective: OBJ = -267969.2324 (MAXimum) Page 17 592 593 No. Column name St Activity 594 595 596 31 P2GPA 597 Obj coef Lower bound Marginal Upper bound Activity range BS 300.00000 -4.60000 +Inf 230.00000 370.00000 598 599 32 P2GPB NL 600 -5.00000 -21.68179 +Inf 50.00000 601 602 33 P2WPA BS 125.00000 -6.30000 603 +Inf 55.00000 154.16198 604 605 34 P2WPB NL -6.50000 606 -1.30000 +Inf 50.00000 607 608 35 P3FPA NL -5.50000 609 -15.63591 +Inf 25.90090 Obj coef Obj value at Limiting range break point variable -9.02842 -269297.75868 S1GPA -3.25000 -267564.23237 S2GPA -Inf -267969.23237 C51 16.68179 -269053.32165 C67 -7.65000 -268137.98237 S2GPA -3.80433-267657.27365 P1FPA -Inf -267969.23237 S2WPB -5.20000 -268034.23237 _067 -Inf -267969.23237 C108 10.13591 -268374.21643 C106 610 611 36 P3FPB BS 285.74479 -5.70000 612 +Inf 285.74479 314.90676 -6.73282 -268264.35544 S3GPB -5.70000 -267969.23237 03PA 613 614 37 P3GPA BS 295.00000 -4.60000 615 +Inf 225.00000 295.00000 -5.95000 -268367.48237 S2GPA -3.90000 -267762.73237 S3GPB 616 617 38 P3GPB NL -5.00000 618 -20.98179 +Inf 107.33333 619 620 39 P3WPA BS 30.26316 -6.30000 621 +Inf 30.26316 64.23205 622 623 40 P3WPB BS 84.73684 -6.50000 624 +Inf 50.76795 84.73684 -Inf -267969.23237 C119 15.98179-270221.27737 C118 -7.18667-267996.06570 S3GPB -6.30000 -267969.23237 03PA -6.50000 -267969.23237 03PA -5.61333-267894.09903 S3GPB 625 626 GLPK 4.65 SENSITIVITY ANALYSIS REPORT 627 628 Problem: Page 18 629 Objective: OBJ = -267969.2324 (MAXimum) 630 631 No. Column name St Activity 632 Obj coef Marginal Lower bound Upper bound Activity range 633 634 41 P4FPA NL -5.50000 635 -15.63591 +Inf 39.55423 Obj coef Obj value at Limiting range break point variable -Inf -267969.23237 C111 10.13591 -268587.69864 05PA 636 637 42 P4FPB BS 269.82677 -5.70000 638 +Inf 639 640 43 P4GPA BS 245.00000 -4.60000 641 +Inf 269.82677 269.82677 245.00000 245.00000 -5.70000 -267969.23237 _C59 -3.63436 -267411.86712 S3GPB 642 643 44 P4GPB NL -5.00000 644 -20.98179 +Inf 645 646 45 P4WPA BS 86.72129 -6.30000 647 +Inf 86.72129 109.75837 648 649 46 P4WPB BS 103.27871 -6.50000 650 +Inf 103.27871 103.27871 651 652 47 P5FPA NL 653 -5.50000 -15.63591 +Inf -39.31219 29.16198 -5.30000 -268140.73237 S3GPB -3.90000 -267797.73237 S4GPB -Inf -267969.23237 C122 15.98179 -267969.23237 _061 -6.30000 -267969.23237 C59 -5.10000 -267865.16682 S4WPA -8.27333 -268152.37995 S3GPB -6.50000 -267969.23237 _C59 -Inf -267354.55063 05PA 10.13591 -268425.20632 04PA 654 655 48 P5FPB BS 269.82677 -5.70000 656 +Inf 255.24578 269.82677 -5.70000 -267969.23237 03PA -5.70000 -267969.23237 _C59 657 658 49 P5GPA BS 240.00000 -4.60000 659 +Inf 240.00000 283.74297 660 661 50 P5GPB NL -5.00000 662 -20.98179 +Inf -5.30000 -268137.23237 S4GPB 117.16310-238746.08731 Mf4G -Inf -267969.23237 _C61 15.98179 -267969.23237 _C60 663 663 664 GLPK 4.65 SENSITIVITY ANALYSIS REPORT 665 666 Problem: 667 Objective: OBJ = -267969.2324 (MAXimum) Page 19 668 669 No. Column name St Activity 670 Obj coef Lower bound Marginal Upper bound Activity range range Obj coef Obj value at Limiting break point variable 671 672 51 P5WPA BS 96.72129 -6.30000 673 +Inf 79.73684 96.72129 -6.30000 -267969.23237 03PA -6.30000 -267969.23237 _C59 674 675 52 P5WPB BS 103.27871 -6.50000 676 +Inf 103.27871 120.26316 -6.50000 -267969.23237 C59 -6.50000 -267969.23237 03PA 677 678 53 R1P1PA BS 66421.05263 -1.25000 679 +Inf 65001.63176 71800.00000 -1.30127 -271374.87167 P1FPA -1.19237-264141.37801 S1GPA 680 681 54 R1P1PB BS 38830.52632 -1.45000 682 +Inf 36060.00000 39753.88661 -1.56189 -272313.91386 S1GPA -1.37118 -264908.63524 P1FPA 683 684 55 R1P2PA BS 93250.00000 -1.25000 93250.00000 685 +Inf 98907.42359 -1.27386 -270194.05574 C116 -1.23714 -266769.63853 P1FPA 686 687 56 R1P2PB BS 60943.39623 -1.45000 30797.70495 -1.65760-280620.93566 C76 688 +Inf 63046.22642 -1.41909 -266085.42797 P2WPB 689 690 57 R1P3PA BS 73721.05263 -1.25000 691 +Inf 68342.10526 80311.01857 -1.26757-269264.40018 S2GPA -1.25000 -267969.23237 03PA 692 693 58 R1P3PB BS 64507.14002 -1.45000 694 +Inf 63078.52359 64507.14002 -1.45000 -267969.23237 03PA -1.42892 -266609.24783 S3GPB 695 696 59 R1P4PA BS 73173.93034 -1.25000 697 +Inf 73173.93034 73173.93034 -1.25000 -267969.23237 _C59 -1.24696 -267746.52910 S4GPB 698 699 60 R1P4PB BS 65286.94799 -1.45000 700 +Inf 65286.94799 65286.94799 -1.49217 -270722.08235 S3GPB -1.45000 -267969.23237 _C59 701 702 GLPK 4.65 SENSITIVITY ANALYSIS REPORT 703 704 Problem: 705 Objective: OBJ = -267969.2324 (MAXimum) Page 20 706 707 No. Column name St Activity 708 Obj coef Marginal Lower bound Upper bound Activity range range 709 710 61 R1P5PA BS 73963.93034 -1.25000 711 +Inf 70668.94737 73963.93034 Obj coef Obj value at Limiting break point variable -1.25000 -267969.23237 03PA -1.25000 -267969.23237 _C59 712 713 62 R1P5PB BS 65286.94799 -1.45000 714 +Inf 65286.94799 66001.25621 -1.45000 -267969.23237 C59 -1.45000 -267969.23237 03PA 715 716 63 R1PA BS 2500.00000 -11.00000 717 +Inf 2165.00000 2500.00000 -14.13579 -275808.70605 _C70 +Inf +Inf 718 719 64 R1PB BS 2330.10526 -11.00000 720 +Inf 2196.00000 2374.79983 721 722 65 R2P1PA BS 905.26316 -2.65000 723 +Inf 430.00000 950.51027 724 725 66 R2P1PB BS 2371.57895 -2.90000 726 +Inf 2236.00000 2416.76466 727 728 67 R2P2PA BS 1075.00000 -2.65000 729 +Inf 473.00000 1325.79300 730 731 68 R2P2PB BS 3871.69811 -2.90000 732 +Inf 3474.33962 4186.64747 733 734 69 R2P3PA BS 260.26316 -2.65000 735 +Inf 260.26316 552.39567 736 737 70 R2P3PB BS 3865.62264 -2.90000 738 +Inf 2993.57895 3868.05815 -13.31154 -273355.36030 S1GPA -9.37164 -264174.99160 P1FPA -3.30225 -268559.68851 S1GPA -1.04153 -266513.14282 P1FPA -5.18641 -273391.64141 S1GPA -1.28934-264149.43349 P1FPA -2.80698 -268137.98237 S2GPA -2.35981 -267657.27365 P1FPA -5.62824 -278532.15361 P2GPB -.76959 -259720.93566 02PB -2.75310 -267996.06570 S3GPB -2.65000 -267969.23237 03PA -5.08811 -276427.64186 _C77 -2.90000 -267969.23237 03PA 739 739 740 GLPK 4.65 741 742 Problem: - SENSITIVITY ANALYSIS REPORT Page 21 743 Objective: OBJ = -267969.2324 (MAXimum) 744 745 No. Column name St Activity 746 Obj coef Marginal Lower bound Upper bound Activity range range Obj coef Obj value at Limiting break point variable 747 748 71 R2P4PA BS 745.80310 -2.65000 749 +Inf 745.80310 943.92198 -2.65000 -267969.23237 C59 -2.51047 -267865.16682 S4WPA 750 751 72 R2P4PB BS 3864.29322 -2.90000 752 +Inf 3864.29322 5000.00000 -2.90000 -267969.23237 _C59 256762.78292 _C41 753 754 73 R2P5PA BS 831.80310 -2.65000 755 +Inf 685.73684 831.80310 -2.65000 -267969.23237 03PA -2.65000 -267969.23237 _C59 756 757 74 R2P5PB BS 3864.29322 -2.90000 758 +Inf 3863.07547 3864.29322 -2.90000 -267969.23237 03PA -2.90000 -267969.23237 _C59 759 760 75 R2PA BS 2500.00000 -11.00000 761 +Inf -Inf 2500.00000 -16.50000 -281719.23237 C71 +Inf +Inf 762 763 76 R2PB BS 3800.00000 -11.00000 1920.32749 -14.32940-280620.93566 _C76 764 +Inf 3800.00000 +Inf +Inf 765 766 77 R3PA BS 2500.00000 -11.55000 2212.50000 767 +Inf 2500.00000 -17.32500 -282406.73237 C72 +Inf +Inf 768 769 78 R3PB BS 3800.00000 -12.10000 770 +Inf 2944.10526 3800.00000 -14.32940-276440.93566 _C77 +Inf +Inf 771 772 79 R4PA BS 2500.00000 -11.55000 773 +Inf -Inf 2500.00000 -17.32500 -282406.73237 C73 +Inf +Inf 774 775 80 R4PB BS 3800.00000 -12.10000 3800.00000 -14.32940 -276440.93566 C78 776 +Inf 3800.00000 +Inf +Inf 778 GLPK 4.65 - SENSITIVITY ANALYSIS REPORT 779 780 Problem: 781 Objective: OBJ = -267969.2324 (MAXimum) Page 22 782 783 No. Column name St Activity 784 Obj coef Lower bound Marginal Upper bound Activity range 785 786 81 R5PA BS 2500.00000 -11.55000 787 +Inf -Inf 2500.00000 Obj coef Obj value at Limiting range break point variable -17.32500-282406.73237 _C74 +Inf +Inf 788 789 82 R5PB BS 3800.00000 -12.10000 2955.67251 -14.32940-276440.93566 _C79 790 +Inf 3800.00000 +Inf +Inf 791 792 83 S1FPA BS -1.00000 -35.26316 793 +Inf 29.16198 -14.03159 -267969.23237 1.49567 -267969.23237 P1FPA C102 794 795 84 S1FPB BS 50.00000 -1.30000 796 +Inf 50.00000 -14.13159 -268610.81204 S1WPB +Inf +Inf 797 798 85 S1GPA NL -.90000 799 -4.42842 +Inf 70.00000 800 801 86 S1GPB NL -.70000 802 -16.96001 +Inf -Inf -267969.23237 C48 3.52842 -268279.22184 S1WPA -Inf -267969.23237 C48 C113 16.26001-267969.23237 803 804 87 S1WPA BS 70.00000 -1.20000 805 +Inf 40.83802 70.00000 11.83159-267057.02083 -3.69567 -268143.92925 P1FPA C102 806 807 88 S1WPB NL -1.30000 808 -12.83159 +Inf -29.16198 50.00000 809 810 89 S2FPA NL -1.00000 811 -7.63750 +Inf 812 813 90 S2FPB NL -1.30000 814 -1.30000 +Inf 50.00000 -Inf -267595.03773 04PA 11.53159 -268610.81204 S1FPB -Inf -267969.23237 C52 6.63750 -267969.23237 C105 -Inf -267969.23237 _C52 -268034.23237 _067 815 816 GLPK 4.65 SENSITIVITY ANALYSIS REPORT 817 818 Problem: 819 Objective: OBJ = -267969.2324 (MAXimum) Page 23 820 821 No. Column name St Activity 822 Obj coef Marginal Lower bound Upper bound Activity range 823 824 91 S2GPA NL -.90000 825 -1.35000 +Inf 70.00000 Obj coef Obj value at Limiting range break point variable -Inf -267969.23237 C51 .45000 -268063.73237 S2WPA 826 827 92 S2GPB BS -.70000 828 +Inf 50.00000 -6.18750 -267969.23237 C116 20.98179 -267969.23237 P2GPB 829 830 93 S2WPA BS 70.00000 -1.20000 831 +Inf 70.00000 -2.55000 -268063.73237 S2GPA +Inf +Inf 832 833 94 S2WPB BS -1.30000 834 +Inf -55.00000 50.00000 -7.83750 -267969.23237 C115 -267969.23237 P2WPB 835 836 95 S3FPA NL F -1.00000 837 -1.00000 +Inf -Inf -267969.23237 C55 -267969.23237 C108 838 839 96 S3FPB NL -1.30000 840 -1.30000 +Inf 50.00000 841 842 97 S3GPA NL -.90000 843 -.90000 +Inf 38.33333 844 845 98 S3GPB NL -.70000 846 -.70000 +Inf 847 848 99 S3WPA NL -1.20000 849 -1.20000 +Inf 30.26316 -Inf -267969.23237 _C55 -268034.23237 _C68 -Inf -267969.23237 C54 -268003.73237 C106 -Inf -267969.23237 C54 -267969.23237 C119 -Inf -267969.23237 C53 -268005.54816 _C106 850 851 100 S3WPB NL -1.30000 852 -1.30000 +Inf 33.96890 -Inf -267969.23237 _C53 -268013.39193 04PA 853 854 GLPK 4.65 SENSITIVITY ANALYSIS REPORT 855 856 Problem: 857 Objective: OBJ = -267969.2324 (MAXimum) Page 24 858 859 No. Column name St Activity 860 Obj coef Lower bound Marginal Upper bound Activity range range 861 862 101 S4FPA NL -1.00000 863 -1.00000 +Inf Obj coef Obj value at Limiting break point variable -Inf -267969.23237 C58 -267969.23237 C111 864 865 102 S4FPB NL -1.30000 866 -1.30000 +Inf 34.82677 -Inf -267969.23237 C58 -268014.50717 Mf3F 867 868 103 S4GPA NL -.90000 869 -.90000 +Inf 29.18030 870 871 104 S4GPB NL -.70000 872 -.70000 +Inf 873 874 105 S4WPA NL -1.20000 875 -1.20000 +Inf 23.03708 -Inf -267969.23237 _057 -267995.49464 05PA -Inf -267969.23237 _C57 -267969.23237 C122 -Inf -267969.23237 C56 -267996.87686 05PA 876 877 106 S4WPB NL -1.30000 878 -1.30000 +Inf 23.03708 -Inf -267969.23237 C56 -267999.18057 05PA 879 880 End of report 881