**************************************************** * RARDIN, OPTIMIZATION IN O.R., P.131-153 * * OPERATIONS PLANNING MODELS * * EXAMPLE 4.3 - TUBULAR PRODUCTS MODEL * * DSN = R139.SAS * ****************************************************; DATA NEW; INPUT _TYPE_ $ _ROW_ $ _COL_ $ _COEF_; ** [PRODUCT = Xpm WHERE p=Product AND m=Mill]; CARDS; MIN COST . . . COST X1-1 90.0 . COST X2-1 80.0 . COST X3-1 104.0 . COST X4-1 98.0 . COST X5-1 123.0 . COST X6-1 113.0 . COST X9-1 140.0 . COST X10-1 124.0 . COST X11-1 160.0 . COST X12-1 143.0 . COST X13-1 202.0 . COST X14-1 190.0 . COST X1-2 75.0 . COST X2-2 70.0 . COST X3-2 85.0 . COST X4-2 79.0 . COST X5-2 101.0 . COST X6-2 94.0 . COST X7-2 160.0 . COST X8-2 142.0 . COST X9-2 110.0 . COST X10-2 96.0 . COST X11-2 133.0 . COST X12-2 127.0 . COST X13-2 150.0 . COST X14-2 141.0 . COST X15-2 190.0 . COST X16-2 175.0 . COST X1-3 70.0 . COST X2-3 65.0 . COST X3-3 83.0 . COST X4-3 80.0 . COST X5-3 110.0 . COST X6-3 100.0 . COST X7-3 156.0 . COST X8-3 150.0 . COST X1-4 63.0 . COST X2-4 60.0 . COST X3-4 77.0 . COST X4-4 74.0 . COST X5-4 99.0 . COST X6-4 84.0 . COST X7-4 140.0 . COST X8-4 130.0 . COST X9-4 122.0 . COST X10-4 101.0 . COST X11-4 138.0 . COST X12-4 133.0 . COST X13-4 160.0 . COST X14-4 140.0 . COST X15-4 220.0 . COST X16-4 200.0 GE DEMAND1 X1-1 1.0 . DEMAND1 X1-2 1.0 . DEMAND1 X1-3 1.0 . DEMAND1 X1-4 1.0 . DEMAND1 _RHS_ 100.0 GE DEMAND2 X2-1 1.0 . DEMAND2 X2-2 1.0 . DEMAND2 X2-3 1.0 . DEMAND2 X2-4 1.0 . DEMAND2 _RHS_ 630.0 GE DEMAND3 X3-1 1.0 . DEMAND3 X3-2 1.0 . DEMAND3 X3-3 1.0 . DEMAND3 X3-4 1.0 . DEMAND3 _RHS_ 500.0 GE DEMAND4 X4-1 1.0 . DEMAND4 X4-2 1.0 . DEMAND4 X4-3 1.0 . DEMAND4 X4-4 1.0 . DEMAND4 _RHS_ 980.0 GE DEMAND5 X5-1 1.0 . DEMAND5 X5-2 1.0 . DEMAND5 X5-3 1.0 . DEMAND5 X5-4 1.0 . DEMAND5 _RHS_ 720.0 GE DEMAND6 X6-1 1.0 . DEMAND6 X6-2 1.0 . DEMAND6 X6-3 1.0 . DEMAND6 X6-4 1.0 . DEMAND6 _RHS_ 240.0 GE DEMAND7 X7-2 1.0 . DEMAND7 X7-3 1.0 . DEMAND7 X7-4 1.0 . DEMAND7 _RHS_ 75.0 GE DEMAND8 X8-2 1.0 . DEMAND8 X8-3 1.0 . DEMAND8 X8-4 1.0 . DEMAND8 _RHS_ 22.0 GE DEMAND9 X9-1 1.0 . DEMAND9 X9-2 1.0 . DEMAND9 X9-4 1.0 . DEMAND9 _RHS_ 50.0 GE DEMAND10 X10-1 1.0 . DEMAND10 X10-2 1.0 . DEMAND10 X10-4 1.0 . DEMAND10 _RHS_ 22.0 GE DEMAND11 X11-1 1.0 . DEMAND11 X11-2 1.0 . DEMAND11 X11-4 1.0 . DEMAND11 _RHS_ 353.0 GE DEMAND12 X12-1 1.0 . DEMAND12 X12-2 1.0 . DEMAND12 X12-4 1.0 . DEMAND12 _RHS_ 55.0 GE DEMAND13 X13-1 1.0 . DEMAND13 X13-2 1.0 . DEMAND13 X13-4 1.0 . DEMAND13 _RHS_ 125.0 GE DEMAND14 X14-1 1.0 . DEMAND14 X14-2 1.0 . DEMAND14 X14-4 1.0 . DEMAND14 _RHS_ 35.0 GE DEMAND15 X15-2 1.0 . DEMAND15 X15-4 1.0 . DEMAND15 _RHS_ 100.0 GE DEMAND16 X16-2 1.0 . DEMAND16 X16-4 1.0 . DEMAND16 _RHS_ 10.0 LE CAPCTY1 X1-1 0.8 . CAPCTY1 X2-1 0.8 . CAPCTY1 X3-1 0.8 . CAPCTY1 X4-1 0.8 . CAPCTY1 X5-1 0.8 . CAPCTY1 X6-1 0.8 . CAPCTY1 X9-1 1.5 . CAPCTY1 X10-1 1.5 . CAPCTY1 X11-1 1.5 . CAPCTY1 X12-1 1.5 . CAPCTY1 X13-1 1.5 . CAPCTY1 X14-1 1.5 . CAPCTY1 _RHS_ 800.0 LE CAPCTY2 X1-2 0.7 . CAPCTY2 X2-2 0.7 . CAPCTY2 X3-2 0.7 . CAPCTY2 X4-2 0.7 . CAPCTY2 X5-2 0.7 . CAPCTY2 X6-2 0.7 . CAPCTY2 X7-2 0.9 . CAPCTY2 X8-2 0.9 . CAPCTY2 X9-2 0.9 . CAPCTY2 X10-2 0.9 . CAPCTY2 X11-2 0.9 . CAPCTY2 X12-2 0.9 . CAPCTY2 X13-2 0.9 . CAPCTY2 X14-2 0.9 . CAPCTY2 X15-2 1.0 . CAPCTY2 X16-2 1.0 . CAPCTY2 _RHS_ 480.0 LE CAPCTY3 X1-3 0.5 . CAPCTY3 X2-3 0.5 . CAPCTY3 X3-3 0.5 . CAPCTY3 X4-3 0.5 . CAPCTY3 X5-3 0.5 . CAPCTY3 X6-3 0.5 . CAPCTY3 X7-3 0.5 . CAPCTY3 X8-3 0.5 . CAPCTY3 _RHS_ 1280.0 LE CAPCTY4 X1-4 0.6 . CAPCTY4 X2-4 0.6 . CAPCTY4 X3-4 0.6 . CAPCTY4 X4-4 0.6 . CAPCTY4 X5-4 0.6 . CAPCTY4 X6-4 0.6 . CAPCTY4 X7-4 0.6 . CAPCTY4 X8-4 0.6 . CAPCTY4 X9-4 1.2 . CAPCTY4 X10-4 1.2 . CAPCTY4 X11-4 1.2 . CAPCTY4 X12-4 1.2 . CAPCTY4 X13-4 1.2 . CAPCTY4 X14-4 1.2 . CAPCTY4 X15-4 1.5 . CAPCTY4 X16-4 1.5 . CAPCTY4 _RHS_ 960.0 EQ FORCE1 X10-2 1.0 . FORCE1 _RHS_ 22.0 EQ FORCE2 X11-2 1.0 . FORCE2 _RHS_ 214.1 EQ FORCE3 X10-4 1.0 . FORCE3 _RHS_ 0.0 EQ FORCE4 X11-4 1.0 . FORCE4 _RHS_ 138.9 ; ***THIS PROBLEM HAS MULTIPLE OPTIMAL SOLUTIONS; ***ROWS FORCE1-4 RESULT IN SOLUTION LISTED; PROC LP SPARSEDATA ; TITLE 'TUBULAR PRODUCTS OPERATIONS PLANNING PROBLEM'; RUN;