8/16/2019 grupo_120_102016_TC1 (2)

1/11

.

 ANÁLISIS, SOLUCIÓN DE PROBLEMAS DE PLE Y TRANSPORTES EINTERPRETACIÓN DE RESULTADOS MEDIANTE EL USO DEL SOLVER DE

EXCEL, UNIDAD 1

SANDRA MILENA CASTILLO FLOREZCODIGO 3757671

TUTORADIANA AT!ERINE TRILLEROS MOICA

UNIVERSIDAD NACIONAL ABIERTA Y A DISTANCIA " UNAD#$16

8/16/2019 grupo_120_102016_TC1 (2)

2/11

.

INTRODUCCION

M%&'()*% %+*% *(-(/ +% -0+( %(2'( 2( 0)'&(& 1 %) 2( 0(2 +% %42%(( 2(*%4*'( %+*0&'(&( &% 0)( /4( *'( 8 4%&'()*% (+/+ 8 *9)'(+ (( 2(

/)+*0':) &% 4/&%2/+ 4(*%4*'/+, P/;(4(':) %)*%( 8 M/&%2/+ &%*()+/*%, (( +/20'/)( /-2%4(+ /0%+*/+ %) 2( ;0

8/16/2019 grupo_120_102016_TC1 (2)

3/11

.

DESARROLLO

U)( %4%+( >00%+(( *()+/*( 4'4/ 35 */)%2(&(+ ( 2(%4%+( +/2''*()*%. S% &'+/)%) &% 11 *()>0%+ &%2 *'/ 1, /) (('&(& ((1$2'*/+ 8 /) 0)( 0*'2'&(& &% 73$.$$$ / ='(%, &% 13*()>0%+ *'/ # /) 0)((('&(& &% */)%2(&(+ 8 0)( 0*'2'&(& &% 65.$$$ / ='(%, &% 1# *()>0%+ *'/3 /) (('&(& (( 11 */)%2(&(+ 8 0)( 0*'2'&(& &% 715.$$$ / ='(% 8 &%1*()>0%+ *'/ /) (('&(& (( 1$ */)%2(&(+ 8 0)( 0*'2'&(& &% 6$.$$$ / ='(%

MAX Z73$$$$X165$$$X#715$$$X36$$$$XRESTRICCIONESHX111X#13X31#X11$X1X#11X31$X35

8/16/2019 grupo_120_102016_TC1 (2)

4/11

.

R%+/2='%)&/ /) =('(-2%+ /)*')J(+, %+/)&()H

(. K09 ()*'&(& &% *()>0%+ &%-%) 0+(+%

D%2 *'/ 1H 11 *()>0%+D%2 *'/ #H 13 *()>0%+D%2 *'/ 3H 6,1 *()>0%+D%2 *'/ H 1 *()>0%+

-. KC02 %+ 2( 0*'2'&(& ;%)%(&( %) %2 +'+*%4( &% &'+*'-0':)

L( 0*'2'&(& ;%)%(&( %+ &% 31.15.$$$ %+/+.

R%+/2='%)&/ /) =('(-2%+ %)*%(+, %+/)&()H

. K09 ()*'&(& &% *()>0%+ &%-%) 0+(+%

D%2 *'/ 1H 11 *()>0%+D%2 *'/ #H 13 *()>0%+D%2 *'/ 3H 6 *()>0%+D%2 *'/ H 1 *()>0%+

%. KC02 %+ 2( 0*'2'&(& ;%)%(&( %) %2 +'+*%4( &% &'+*'-0':)

L( 0*'2'&(& ;%)%(&( %+ &% 31.$15.$$$ %+/+.

8/16/2019 grupo_120_102016_TC1 (2)

5/11

.

P/-2%4( #. D%+4()?(&/ @L( L'(

K09 49*/&/ ;%)%( %2 /+*/ 40%/

8/16/2019 grupo_120_102016_TC1 (2)

6/11

.

D%+&% 2( -/&%;( 5 ?(+*( %2 &%+*')/ 1H 35$D%+&% 2( -/&%;( 6 ?(+*( %2 &%+*')/ #H 7$, &%+*')/ 3H 3$, &%+*')/ H 5$, &%+*')/ 5H1$

P/-2%4( 3. D%+')%*()*% @E2 B2()>0'*/

K09 49*/&/ ;%)%( %2 /+*/ 40%/0'*/,+%;J) &'?/ 49*/&/

8/16/2019 grupo_120_102016_TC1 (2)

7/11

.

E2 4%/ (2;/'*4/ &% *()+/*% %+ %2 &% =/;%2 /) 0) /+*/ &% %)='/H #.57$,2(+ (+';)('/)%+ +%

8/16/2019 grupo_120_102016_TC1 (2)

8/11

.

K09 49*/&/ ;%)%( %2 /+*/ 40%/

8/16/2019 grupo_120_102016_TC1 (2)

9/11

.

CONCLUSIONES

C/) 2( %2(-/(':) &% %+*% *(-(/ +% 0&/ /4%)&% 2/ '4/*()*% >0% 0%%(2'( 2( (*'='&(& &% %+*% *(-(/ +% /&

8/16/2019 grupo_120_102016_TC1 (2)

10/11

.

BIBLIOGRAFIA

C/22(/+ ,P. L(?/, D. #$1Q. M/&%2/+ &% ')=%+*';(':) /%(*'=(. U)'=%+'&(&&% Z((;/(.R%0%(&/ &%H ?**H/.0)'(.%+/%)+%)()(+*%)'(+4/&%2/+&%')=%+*';('/)/%(*'=('?%/+OCP/;(4('/)L')%(2.& 

M/(, N. #$11Q. I)=%+*';(':) O%(*'=(. R%0%(&/ &%H?**H/.034.%+%+*(&'+*'(')=%+*';('/)/%(*'=(

O%)C/0+%(%. U)'(. +..Q.B%=% 4()0(2 &%2 S/2=%. R%0%(&/ &%H?**H/.0)'(.%+/%)+%)()(+*%)'(+4/&%2/+&%')=%+*';('/)/%(*'=('?%/+CURSOSOLVER.& 

M'*/%)/0+%(%. M(++(?0+%**+ I)+*'*0*% / T%?)/2/;8. +,Q. I)*/&0':) ( 2(P/;(4(':) 2')%(2 %)*%(.R%0%(&/ &%H?**H4'*./.0)'=%+'(.)%*15.$53+$#&+$#2%1-.& 

M'*/%)/0+%(%. M(++(?0+%**+ I)+*'*0*% / T%?)/2/;8. +,Q. R(4''(':) 8(/*(4'%)*/ B()?B/0)&Q. R%0%(&/ &%H?**H4'*./.0)'=%+'(.)%*15.$53+$#&+$#2%15.& 

O%)C/0+%(%. U)'(. +..Q. B%=% 4()0(2 &%2 S/2=%. R%0%(&/ &%H?**H/.0)'(.%+/%)+%)()(+*%)'(+4/&%2/+&%')=%+*';('/)/%(*'=('?%/+CURSOSOLVER.& 

B(0*'+*(, . #$11Q. E2 /-2%4( &% *()+/*% / &'+*'-0':), /;(4(':)2/'/'W*()+/*%W(+';)('/)W%-1$.& 

http://ocw.unizar.es/ocw/ensenanzas-tecnicas/modelos-de-investigacion-operativa/ficheros/OCWProgramacionLineal.pdfhttp://ocw.unizar.es/ocw/ensenanzas-tecnicas/modelos-de-investigacion-operativa/ficheros/OCWProgramacionLineal.pdfhttp://ocw.uc3m.es/estadistica/investigacion-operativahttp://ocw.unizar.es/ocw/ensenanzas-tecnicas/modelos-de-investigacion-operativa/ficheros/CURSOSOLVER.pdfhttp://ocw.unizar.es/ocw/ensenanzas-tecnicas/modelos-de-investigacion-operativa/ficheros/CURSOSOLVER.pdfhttp://mit.ocw.universia.net/15.053/s02/pdf/s02-lec14b.pdfhttp://mit.ocw.universia.net/15.053/s02/pdf/s02-lec15.pdfhttp://ocw.unizar.es/ocw/ensenanzas-tecnicas/modelos-de-investigacion-operativa/ficheros/CURSOSOLVER.pdfhttp://ocw.unizar.es/ocw/ensenanzas-tecnicas/modelos-de-investigacion-operativa/ficheros/CURSOSOLVER.pdfhttp://ocw.upc.edu/sites/default/files/materials/15014276/tr_mqoioi_transporte_asignacion_web-4410.pdfhttp://ocw.upc.edu/sites/default/files/materials/15014276/tr_mqoioi_transporte_asignacion_web-4410.pdfhttp://ocw.upc.edu/sites/default/files/materials/15014276/tr_mqoioi_transporte_asignacion_web-4410.pdfhttp://ocw.upc.edu/sites/default/files/materials/15014276/tr_mqoioi_transporte_asignacion_web-4410.pdfhttp://ocw.upc.edu/sites/default/files/materials/15014276/tr_mqoioi_transporte_asignacion_web-4410.pdfhttp://ocw.upc.edu/sites/default/files/materials/15014276/tr_mqoioi_transporte_asignacion_web-4410.pdfhttp://ocw.upc.edu/sites/default/files/materials/15014276/tr_mqoioi_transporte_asignacion_web-4410.pdfhttp://ocw.upc.edu/sites/default/files/materials/15014276/tr_mqoioi_transporte_asignacion_web-4410.pdfhttp://ocw.uc3m.es/estadistica/investigacion-operativahttp://ocw.unizar.es/ocw/ensenanzas-tecnicas/modelos-de-investigacion-operativa/ficheros/CURSOSOLVER.pdfhttp://ocw.unizar.es/ocw/ensenanzas-tecnicas/modelos-de-investigacion-operativa/ficheros/CURSOSOLVER.pdfhttp://mit.ocw.universia.net/15.053/s02/pdf/s02-lec14b.pdfhttp://mit.ocw.universia.net/15.053/s02/pdf/s02-lec15.pdfhttp://ocw.unizar.es/ocw/ensenanzas-tecnicas/modelos-de-investigacion-operativa/ficheros/CURSOSOLVER.pdfhttp://ocw.unizar.es/ocw/ensenanzas-tecnicas/modelos-de-investigacion-operativa/ficheros/CURSOSOLVER.pdfhttp://ocw.upc.edu/sites/default/files/materials/15014276/tr_mqoioi_transporte_asignacion_web-4410.pdfhttp://ocw.upc.edu/sites/default/files/materials/15014276/tr_mqoioi_transporte_asignacion_web-4410.pdfhttp://ocw.upc.edu/sites/default/files/materials/15014276/tr_mqoioi_transporte_asignacion_web-4410.pdfhttp://ocw.upc.edu/sites/default/files/materials/15014276/tr_mqoioi_transporte_asignacion_web-4410.pdfhttp://ocw.upc.edu/sites/default/files/materials/15014276/tr_mqoioi_transporte_asignacion_web-4410.pdfhttp://ocw.upc.edu/sites/default/files/materials/15014276/tr_mqoioi_transporte_asignacion_web-4410.pdfhttp://ocw.upc.edu/sites/default/files/materials/15014276/tr_mqoioi_transporte_asignacion_web-4410.pdfhttp://ocw.upc.edu/sites/default/files/materials/15014276/tr_mqoioi_transporte_asignacion_web-4410.pdfhttp://ocw.unizar.es/ocw/ensenanzas-tecnicas/modelos-de-investigacion-operativa/ficheros/OCWProgramacionLineal.pdfhttp://ocw.unizar.es/ocw/ensenanzas-tecnicas/modelos-de-investigacion-operativa/ficheros/OCWProgramacionLineal.pdf

8/16/2019 grupo_120_102016_TC1 (2)

11/11

.

O%)C/0+%(%. U)'(. +..Q. B%=% 4()0(2 &%2 S/2=%. R%0%(&/ &%H?**H/.0)'(.%+/%)+%)()(+*%)'(+4/&%2/+&%')=%+*';('/)/%(*'=('?%/+CURSOSOLVER.& 

http://ocw.unizar.es/ocw/ensenanzas-tecnicas/modelos-de-investigacion-operativa/ficheros/CURSOSOLVER.pdfhttp://ocw.unizar.es/ocw/ensenanzas-tecnicas/modelos-de-investigacion-operativa/ficheros/CURSOSOLVER.pdfhttp://ocw.unizar.es/ocw/ensenanzas-tecnicas/modelos-de-investigacion-operativa/ficheros/CURSOSOLVER.pdfhttp://ocw.unizar.es/ocw/ensenanzas-tecnicas/modelos-de-investigacion-operativa/ficheros/CURSOSOLVER.pdf