7-267-257-227-217-207-197-187-177-16Instructions RHSMaximize=RTConstraint 1Constraint 2Constraint 3Constraint 4Problem 7-16Problem 7-17BENCHTABLELaborWoodUGMinimizeUndergradGradProblem 7-18Problem 7-19ABLABOR HOURS=DEMAND OF ADEMAND OF BPProblem 7-20XYconst 1const 2const 3Problem 7-22Problem 7-26Input the numbers in the beige cellsWrite formulas to compute values (e.g. profit, resoure utilization) in blue cellsValues found by Solver for decision variables are shown in redProblem 7-25Problem 7-21This file is to guid you to design your own LP problem The other sheets consist of the solution of some selected problems in your textbook page 293.25.0062.5020.0030.002375.005.002.00250.00250.001.002.00150.00150.001.000.0025.0040.000.750.250.900.600.831.001.001.001.0010.006.009.009.0012.009.0011.2510.0018.7518.754.004.00150.003.005.00150.00150.001.00-2.00-18.7510.005.003.00150.00150.0016666.6733333.339.004.00283333.331.001.0050000.0050000.000.120.064000.004000.0020000.0030000.000.120.064200.001.001.0050000.0050000.009.004.00300000.00300000.0010.0024.001200.001800.0055200.0020.0025.00800.00800.001.000.0010.0010.000.001.0024.0015.0040.0020.002500.003000.00160000.001.000.0040.0030.000.001.0020.0020.001.001.0060.0060.00262.5025.009.0020.002862.504.006.001200.001200.0010.0035.003500.003500.00175.0010.003000.007000.00595000.00200.00500.0040000.0040000.001.000.00175.0010.000.001.0010.0010.001.00-1.00165.000.00 7-267-257-227-217-207-197-187-177-16Instructions RHSMaximize=RTConstraint 1Constraint 2Constraint...
No comments:
Post a Comment