grupo_120_102016_TC1 (2)
-
Upload
sandra-castillo -
Category
Documents
-
view
215 -
download
0
Transcript of grupo_120_102016_TC1 (2)
-
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