60
 6 F.O  180 6 1 F.O  1215 48 6 1.5 X 1 R 1 R 2 R 3 R 1 R 2 R 3

Trabajo de Investigación de Operaciones 1

Embed Size (px)

DESCRIPTION

Programación lineal

Citation preview

EJERCICIO 1X1X261.5F.O18090R168R21R31

F.O1215R14848R266R31.54

EJERCICIO 2X1X212525F.O12R113R222R31

F.O175R1200200R2300300R32560

EJERCICIO 3X1X2150100F.O65008300R123R211R321

F.O1805000R1600600R2250500R3400400

EJERCICIO 4X1X2050F.O2500040000R10.250.5R211R31R41F.O2000000R125150R25050R30125R450125

EJERCICIO 5X1X21.250F.O58004200R10.20.32R20.80.68

F.O7250R10.250.25R210.75

EJERCICIO 6X1X2X3000F.O200002200018000R1461R2446R31R41R51

F.O0R1054R2065R307R407R507

EJERCICIO 7X1X22.51011F.O3000025000R14000030000R21R31R41-0.512.50-10

F.O325000R1400000400000R22.510R31025R400

EJERCICIO 8X60X10X11X12X20X21X22X23X30X31X32X33X40X41X42X50X515837.83202200000023100000002702.702702.7F.O1R1111R2-1-1.051111R3-1.11-1-1.051111R4-1.11-1.17-1-1.05111R5-1.17-1.11-1-1.0511R61-1.17-1.11-1-1.05F.O5837.832R122002200R2-00R3-00R400R500R6-00

EJERCICIO 9X111X112X113X121X122X123X211X212X213X221X222X223I11I12I21I22480015801012000000143502800960015500110001000131001000F.O0.830.890.500.830.890.500.710.750.400.710.750.400.200.200.300.30R10.170.14R20.170.14R30.110.13R40.110.13R50.130.10R60.130.10R7-1-1-11R8-1-1-11R9-1-1-1-11R10-1-1-1-11R111R121

F.O38234.4444444444R1800800R2400400R3175.55555555562000R412001200R527002700R615501550R7-5500-5500R8-1250-1250R9-10000-10000R10-40000-40000R1110001000R1210001000

EJERCICIO 10X11X12X13X21X22X23X31X32X33X41X42X43111111111111F.O320320320400400400360360360290290290R11111R21111R31111R414.219.819.911.3R514.219.819.911.3R614.219.819.911.3R7111R8111R9111R10111R1118-1218-1218-1218-12R1210-1210-1210-1210-12R1310-1810-1810-1810-18

F.O4110R1412R2418R3410R465.2200R565.2255R665.2140R7320R8316R9325R10313R11240R12-80R13-320

EJERCICIO 11X1X2X3X4I1I2I3I45.46666666676.8000733.33333333333866.66666666670F.O30000300003000030000303030R1-500-500-5001R2-500-500-500-11R3-500-500-500-11R4-500-500-500-11F.O506000R1-3400-3400R2-2000-2000R3-3000-3000R4-10000-10000

EJERCICIO 12X11X12X21X22X31X32X41X42Y1Y2X11X21X31X41Y1X12X22X32X4204454.5454545454004454.54545454544545.4545454546060004544.45454545460111111111F.O5.25.27.57.53.93.95.15.15.16.35.15.15.15.15.16.36.36.36.3R111R211R311R411R5111111R611111R70.50.5-0.5-0.5-0.5-0.5R8-0.1-0.10.9-0.1-0.1-0.1R91111-0.98R101-0.2R11-0.5-0.511R121111-0.99F.O112091.054545455R14454.54545454548000R2016000R390009000R460006000R590009000R61500015000R7-45000R83554.54545454540R90.980.98R104454.54545454540R118318.18181818180R12150000

EJERCICIO 13X1X2X3X4X5X6X7X8X9X10X11X12X13X1437037.037037037022222.222222222233333.3333333333033333.333333333355555.5555555555001000000010000F.O-650-1250-350-650-12504100-350-450-350-8003200R10.60.3-0.5R2-1-11R30.60.3-0.35R4-1-11R51-0.4R611-1R71-0.2R811-1R90.60.3-1R100.30.6-1R1111R121R131R141R151F.O206259259.259259R13333.33333333330R200R300R400R5-00R6-00R780000R800R9-00R10-00R1165555.55555555551000R1255555.55555555551600R131000010000R1455555.55555555551500R15100002000

EJERCICIO 14X11X12X13X21X22X23X31X32X33000000000F.O375375375330330330275275275R1111R2111R3111R4201512R5201512R6201512R7111R8111R9111R10900-750900-750900-750R11450-750450-750450-750R12450-900450-900450-900F.O0R10750R20900R30450R4013000R5012000R605000R70900R801200R90750R1000R1100R1200

EJERCICIO 15

EJERCICIO 16X11X12X13X21X22X23X31X32X33S1S2S3S4S5S6L1L2L3L4L5L6L71111111111111111111111F.O20020030030040020030040025057406030R1R2R3R4R5R6R7R8R9R10R11

EJERCICIO 17X1X2X3X4X5X6X70010000000F.O-3-25-3-25-100R11-3R22-3R312-3R42-5R53-5R623-5R711R811R911-200F.O5000R1-30000R2-30000R3-30000R400R500R600R7020000R8035000R910001000

EJERCICIO 18Y1Y2Y3Y4Y5X11X12X13X14X15X16X21X22X23X24X25X26X31X32X33X34X35X36X41X42X43X44X45X46X51X52X53X54X55X5600001.75000000000000000000000000111111F.O455055R1-400100200300500800900R2-500100200300500800900R3-600100200300500800900R4-1100100200300500800900R5-1600100200300500800900R611111R711111R811111R911111R1011111R1111111F.O0R100R200R300R400R500R611R711R811R911R1011R1111

INTEGRANTES

UNIVERSIDAD DEL ATLNTICOFACULTAD DE INGENIERAPROGRAMA DE INGENIERA INDUSTRIAL TRABAJO DE INVESTIGACIN DE OPERACIONES 1

EJERCICIOS EN SOLVER DE EXCEL

PRESENTADO POR:

JAIME JAIR FIGUEREDO MALODAVID FRANCISCO BARRIOS CAROLINA CALDERA

AL PROFESOR:

ING. ADEL MENDOZA MENDOZA

BARRANQUILLA, OCTUBRE 3 DE 2014