trabajo colaborativo _ final v2.xlsx

Upload: rafael-rodriguez-caicedo

Post on 01-Mar-2018

219 views

Category:

Documents


0 download

TRANSCRIPT

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    1/293

    P

    P

    DIANA CAROLINA FO

    RAFAEE

    UNIVERSIDAD NACI

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    2/293

    OYECTO FINAL

    ESENTADO POR:

    RERO MARTINEZ COD 1014221415

    TUTOR:

    FRANCISCO ESTRADA

    NAL ABIERTA Y A DISTANCIA UNADBOGOTA 2016

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    3/293

    I

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    4/293

    NTRODUCCION

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    5/293

    RECOME

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    6/293

    NDACIONES DEL CASO

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    7/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    8/293

    ONCLUSIONES

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    9/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    10/293

    BIBLIOGRAFIA

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    11/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    12/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    13/293

    1. El e!"#$%&!e 'e%l$(% el )'*+,- #e l% #e%% /%'% l% 'ee

    200

    00

    400

    500

    600

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    14/293

    El e!"#$%&!e #ee $#e&!$+,%' -!'%' e& el )'*+,-7 l- /%!

    P%!'-&e #e ,-/-'!%$e&!- " 'e,"e&,$%

    Al 'e%l$(%' el %&%l$$ #e l% #e%% 8$!-'$,%7e!%,$-&%l$#%# #e e!- e /'ee&!- ,%#% 2

    T%$e& e&,-&!'%- -!'- /%!'-&e ,$,l$,-

    e&e'- e'e'-0

    100

    9%&12Fe12

    M%'12A/'12

    M%129"&12

    9"l12A")12

    0

    100

    200

    00

    400

    500

    600 C$,l$,$#%#

    E!%,$-&%l$

    #%#

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    15/293

    C-& %

    A/l$,%- l- ;!-#- #e /'

    Promedio Movil

    Me 7 !

    12456>?@

    Promedio movil : e ,%l,"l% % !'%; #e l%

    suavisacion exponencial:El ;!-#- #e "%%&!e'$-'e.

    E!- #- e!-#- &- /e'$!$'%& ,%l,"l%' l%%,e'!%#-.

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    16/293

    1011121141516

    Suavisacion Exponencial

    Pronostico anterior !t"1#

    demanda real At"1#

    Error del pron$stico At"1 " !t" 1

    suavi%aci$n exponencial simple con a &

    Correcci$n a At"1 " !t"1#

    !ormula !t & !t"1 ' a At"1 " !t"1#

    Pronostico anterior !t"1#

    demanda real At"1#

    Error del pron$stico At"1 " !t" 1suavi%aci$n exponencial simple con a &

    Correcci$n a At"1 " !t"1#

    !ormula !t & !t"1 ' a At"1 " !t"1#

    Pronostico anterior !t"1#

    demanda real At"1#

    Error del pron$stico At"1 " !t" 1

    suavi%aci$n exponencial simple con a &

    Correcci$n a At"1 " !t"1#

    !ormula !t & !t"1 ' a At"1 " !t"1#

    Pronostico anterior !t"1#demanda real At"1#

    Error del pron$stico At"1 " !t" 1

    suavi%aci$n exponencial simple con a &

    Correcci$n a At"1 " !t"1#

    !ormula !t & !t"1 ' a At"1 " !t"1#

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    17/293

    Pronostico anterior !t"1#

    demanda real At"1#

    Error del pron$stico At"1 " !t" 1suavi%aci$n exponencial simple con a &

    Correcci$n a At"1 " !t"1#

    !ormula !t & !t"1 ' a At"1 " !t"1#

    El e!"#$%&!e #ee !-%' l% #e,$$

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    18/293

    ALTERNAT)*A A

    Mes

    1

    2

    4

    TOTALES

    Pol+ticas la,orales

    SALARIO MINIMO

    CAPACITACION DE UN OPERARIO NUEVO

    SEMANA ORAS

    DIAS ABILES

    DIAS NORMALES DEL MES

    ORAS ETRASORAS DIARIAS

    NO SE PERMITEN FALTANTES O ENTREGAS TA

    costos so,re la empr

    COSTO DE ALMACENAMIENTO

    COSTO MATERIAL

    Plan de producci$n

    TIEMPO DE PRODUCCION POR UNIDAD H20MINUTOS conversion a -oras

    EMPLEADOS FI9OS HNO SE PUEDENDESPEDIR

    MATERIALES

    UNIDADES DIARIAS JUE SE REJUIEREN PARALA DEMANDA DE LOS 4 MESES

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    19/293

    Cuanto puede producir un solo operario.

    SEMANA

    DIAS ABILES LUNES A VIERNES

    TIEMPO EN PRODUCIR UNA UNIDAD

    CUANTAS UNIDADES POR DIA

    OPERARIOS FI9OS JUE SE NECESITARIAN

    APROIMACION OPERARIOS

    ECESO OPERARIO JUE SE NECESITA

    Mes

    12

    4

    T/TALES

    COSTO DE ALMACENAMIENTO

    1

    2

    4

    TOTALES

    COSTO MATERIAL

    1

    2

    4

    TOTALESCOSTO DE SUB CONTRATACION

    1

    2

    4

    TOTALES

    EMPLEADOS FI9OS YA CONTRATADOS HNO SEPUEDEN DESPEDIR

    FI9OS

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    20/293

    COSTO OPERACIONAL

    CANTIDAD DE OPERARIOS

    ORAS DIARIAS

    DIAS NORMALESCUANTOS DIAS TOTALES

    SALARIO MINIMO OPERARIO

    COSTO DE CADA ORA POR OPERARIO

    TOTAL COSTO

    SUMA DE TODOS LOS COSTES

    CUANT/ C/STAR)A S) SE SUC/NTRATAR

    Mes

    1

    2

    4

    T/TALES

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    21/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    22/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    23/293

    'e&,$% ele,,$-&%#%

    UNATEC CAR

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    24/293

    '-&e #e ,-/-'!%$e&!- #e l% #e%% l% 'e,"e&,$% #e -,"''e&,$% #e ,%#% "&- #e #$,

    &- /e'$!$- !e&e' "&% $$-& % %/l$% #e l- #%!- 8$!-'$,- %/l$%7e&,-&!'%- %ee.

    & el %- 20157 l% ,$,l$,$#%# %l!% #e e!- e /'ee&!% e& e&e'-7 3"l$- #$,$e'e 7 ,-& "&%

    %'(- %'$l %- 3"&$-

    %- 2012 %- 201 %- 20

    e/12O,!12

    N-12De,12

    9%&1Fe1

    M%'1A/'1

    M%19"&1

    9"l1A")1

    Se/1O,!1

    N-1De,1

    9%&14

    #e.%%

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    25/293

    e e& el ,-/-'!%$e&!- -e'%#- e& el )'*+,-7 el e!"#$%&!e #ee /'-/-&e' l- #- ;!

    Los mestodos de pron

    &40 20 @240 21 4>@@2 22 44@44@ 2 ?4?1 24 @411 25 400

    "l!$/l$,%,$

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    26/293

    4@2 26 @6@6 2> ?1426 2? 460415 2@ 411@2 0 40422 1 @2?1 2 452

    9%&12 Fe12 M%'12 A/'12@? @4

    40 @2 @6 4040 @2 1.5 60.1 0.1 0.1 0.1

    40. @.2 0.15 .6

    40 @ @> @?

    9%&1 Fe1 M%'1 A/'1411 421 404 40>415 @2 422 ?14 2?.5 1?.5 26

    0.1 0.1 0.1 0.10.4 2.?5 1.?5 2.6

    411 41? 405 404

    9%&14 Fe14 M%'14 A/'1462 >0 @? ?@400 @6 ?1 460?.5 26.5 1> >1.50.1 0.1 0.1 0.1

    .?5 2.65 1.> >.15

    65 >2 @6 @6

    9%&15 Fe15 M%'15 A/'15?5 41> 42? 41>4> 41? 415 @52.5 1.5 12.5 >>.50.1 0.1 0.1 0.1

    5.25 0.15 1.25 >.>5

    @0 41> 426 40@

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    27/293

    9%&16 Fe16 M%'16 A/'1642 444 4? 44142 444 4? 4410 0 0 0

    0.1 0.1 0.1 0.10 0 0 0

    42 444 4? 441

    P'-#",,$5762@741>

    /-' ="e e!e e!-#- ",% %3"!%' l- /'-&

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    28/293

    El e!"#$%&!e #ee #e%''-ll%' el /l%& %)'e)%#- #e /'-#",,$

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    29/293

    408-'%

    ? #$%

    0./-' 8-'%

    24.0"&$#%#e

    0.@1

    10

    1

    0.0@

    @.0@

    emanda Esperada ias La,orales PR/UCC)/N ST/C3 )N)C)AL

    42 20 4?0 0444 20 4?0 4@

    4? 20 4?0 ?5

    441 20 4?0 12>

    14567845 80 190

    K 071

    K ?72?2K 12742

    K 1?72?

    K 42@702

    K 2?7?00702@

    K 2?7?00702@

    K 2?7?00702@

    K 2?7?00702@

    K 11572007115

    K 0

    K 0

    K 0

    K 0

    K 0

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    30/293

    OPERARIOS JUE SE NECESITAN

    1 10

    ? ?

    20 20?0 ?0

    K 175007000 K 175007000

    K @7>5 K @7>5

    K 670007000.00 K 6070007000

    K 121762@7416.?? K 1>5762@741>

    A T// .

    emanda Esperada T/TAL C/ST/

    42 K 2471647000 K 257?@07000 K 5070547000

    444 K 247?507000 K 2676257000 K 5174>57000

    4? K 24750>7000 K 26725>7500 K 507>647500

    441 K 2476@67000 K 2674607000 K 5171567000

    145; K @?721>7000 K 1057227500 K 20744@7500

    OPERARIOS CON LOS JUE SEDEBE TRABA9AR

    C/ST/ E LASUC/NTRATAC)/N

    C/ST/ EMATER)ALES

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    31/293

    1 2012 e&e'- 402 2012 e'e'- @2 2012 %'(- @64 2012 %'$l 405 2012 %- 406 2012 3"&$- @2> 2012 3"l$- 44@? 2012 %)-!- ?1@ 2012 e/!$e'e 411

    10 2012 -,!"'e 4@211 2012 &-$e'e @6

    12 2012 #$,$e'e 4261 201 e&e'- 41514 201 e'e'- @215 201 %'(- 42216 201 %'$l ?11> 201 %- ?11? 201 3"&$- 4221@ 201 3"l$- 4>20 201 %)-!- @2

    N-. Re)$!'- A- Me UNATEC CAR01

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    32/293

    21 201 e/!$e'e 4>@22 201 -,!"'e 44@2 201 &-$e'e ?424 201 #$,$e'e @25 2014 e&e'- 40026 2014 e'e'- @62> 2014 %'(- ?12? 2014 %'$l 4602@ 2014 %- 4110 2014 3"&$- 401 2014 3"l$- @22 2014 %)-!- 452 2014 e/!$e'e 4004 2014 -,!"'e 4>5 2014 &-$e'e >6 2014 #$,$e'e @6> 2015 e&e'- 4>

    ? 2015 e'e'- 41?@ 2015 %'(- 41540 2015 %'$l @41 2015 %- @242 2015 3"&$- 4114 2015 3"l$- 44@44 2015 %)-!- @645 2015 e/!$e'e >>46 2015 -,!"'e @64> 2015 &-$e'e 40>4? 2015 #$,$e'e 456

    4@ 2016 e&e'- 50 2016 e'e'- 51 2016 %'(- 52 2016 %'$l

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    33/293

    01

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    34/293

    8- /%!'-&e. A')"e&!e " 'e"l!%#-.

    l)"&- /%!'-&e ,$,l$,- e& el %- 2012 7 l% ,$,l$,$#%# %l!% #e e!- #%!- e /'ee&!% e& el

    e!%,$-&%l$#%# #e 4 ee.

    3"l$- %)-!- e/!$e'e -,!"'e &-$

    14 %- 2015

    Fe14M%'14

    A/'14M%14

    9"&149"l14

    A")14Se/14

    O,!14N-14

    De,149%&15

    Fe15M%'15

    A/'15M%15

    9"&15

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    35/293

    -#- #e /'-& 516 @6 52> 4>? 41?@ 41540 @41 @2

    l &e'- #e #% #el /'-e#$-

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    36/293

    42 4114 44@44 @645 >>46 @64> 40>4? 456

    M%12 9"&12 9"l12 A")12 Se/1241 41> @? 421 41540 @2 44@ ?1 41110 24.5 51.5 @.5 40.1 0.1 0.1 0.1 0.1

    1 2.45 5.15 .@5 0.4

    412 414 40 41> 415

    M%1 9"&1 9"l1 A")1 Se/1402 ?1 402 ?5 >0?1 422 4> @2 4>@

    20.5 41 54.5 >.5 [email protected] 0.1 0.1 0.1 0.1

    2.05 4.1 5.45 0.>5 10.@5

    @@ ?5 @6 ?5 ?0

    M%14 9"&14 9"l14 A")14 Se/14421 46 40> @? 422411 40 @2 452 [email protected] 2.5 15 54.5 220.1 0.1 0.1 0.1 0.1

    0.@5 .25 1.5 5.45 2.2

    420 42 406 40 420

    M%15 9"&15 9"l15 A")15 Se/15>> 66 402 40 42@2 411 44@ @6 >>15 45.5 4>.5 4 45.50.1 0.1 0.1 0.1 0.11.5 4.55 4.>5 .4 4.55

    >@ >0 406 42> 41?

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    37/293

    e7 ,-& %e e& l- ;!-#- #e /'-&

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    38/293

    - ,"%!'- ee #e %&e'% ="e e /"e#%& -!e&e' l- ,-!- &$- #e -/e'%,$

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    39/293

    ST/C3 !)NAL ST/C3 ME)/ su,contratacion

    4@ 24 0?5 6> 0

    12> 106 0

    166 14> 0

    6;6 0

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    40/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    41/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    42/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    43/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    44/293

    e #e %'$l 7 3"l$- -,!"'e7 l%

    'e #$,$e'e

    "l15A")15

    Se/15O,!15

    N-15De,15

    Tee&,$%

    E!%,$-&%l$#%#

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    45/293

    !%.

    ,&$,- #e ,%#% ele,,$

    /-e'%,$

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    46/293

    O,!12 N-12 De,12@6 452 4444@2 @6 426@6 55.5 1?0.1 0.1 0.1

    @.6 5.55 1.?

    406 446 442

    O,!1 N-1 De,146 464 41>44@ ?4 @1.5 ?0 >>.50.1 0.1 0.1

    1.5 ? >.>5

    4> 456 40@

    O,!14 N-14 De,14426 >4 604> > @6>@ 0.5 60.1 0.1 0.1>.@ 0.05 .6

    41? > 64

    O,!15 N-15 De,15?> ?> 402@6 40> [email protected] 20.5 54.50.1 0.1 0.1

    0.@5 2.05 5.45

    ?> ?@ 40>

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    47/293

    e " /'-/"e!%.

    !%.

    e

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    48/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    49/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    50/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    51/293

    L200E

    e%&% Se'%&% 1 Se'%&% 2 Se'%&% Se'%&% 4!'$e!'e 1 105 101 106 10?!'$e!'e 2 102 @@ 100 10@

    !'$e!'e 105 @@ 10> @6!'$e!'e 4 101 100 @6 116!'$e!'e 5 110 106 105 ?6

    SL100E

    e%&% Se'%&% 1 Se'%&% 2 Se'%&% Se'%&% 4!'$e!'e 1 24 24? 2>6 225!'$e!'e 2 24? 22@ 24 254!'$e!'e 264 265 261 256

    !'$e!'e 4 11 2>1 20 05!'$e!'e 5 1> 20 12 41

    Se'%&% 1 Se'%&% 2 Se'%&% 0

    20

    40

    60

    ?0

    100

    120

    140

    250

    00

    50

    400

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    52/293

    L200E

    e%&% Se'%&% 1 Se'%&% 2 Se'%&% Se'%&% 4#e%% 105 101 106 10?

    SL100Ee%&% Se'%&% 1 Se'%&% 2 Se'%&% Se'%&% 4

    #e%% 24 24? 2>6 225

    Se'%&% 1 Se'%&% 2 Se'%&% 0

    50

    100

    150

    0

    2040

    60

    ?0

    100

    120

    140

    0

    50

    100

    150

    200

    250

    00

    50400

    e!%,$-&%l$

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    53/293

    ZSDCFG9L

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    54/293

    Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10@1 101 100 101 10@ 10?

    102 @@ 11 @6 104 @@

    @6 10> ?? @@ 121 11104 102 @@ 114 101 ??

    @@ 104 11 100 @5 100

    Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 1022? 24> 2>5 251 251 2412>2 24@ 24? 02 24 24@254 04 2?1 41 02 0

    2 2 2@ 24 11 2450 64 10 2?@ 56 1

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% >

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    55/293

    Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10@1 101 100 101 10@ 10?

    Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10

    22? 24> 2>5 251 251 241

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% >

    !'$e!'e 1 !'$e!'e 2 !'$e!'e !'$e!'e 4

    #e.%% FL200E

    #e.%% SL100E

    %#

    V%'$%,$

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    56/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    57/293

    Se'%&% 11 Se'%&% 12?? 100

    100 10?

    @> ?6@4 100

    10 115

    Se'%&% 11 Se'%&% 1226 2542@2 26124 44

    2? 5542 0?

    Se'%&% ? Se'%&% @ Se'%&% 10 Se'%&% 11

    !'$e!'e 5

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    58/293

    Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&% Se'%&% 4?? 100 102 @@ 100 10@

    Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&% Se'%&% 4

    26 254 24? 22@ 24 254

    Se'%&% ? Se'%&% @ Se'%&% 10 Se'%&% 11

    !'$e!'e 5

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    59/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    60/293

    Se'%&% 12

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    61/293

    Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10102 @@ 11 @6 104 @@

    Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10

    2>2 24@ 24? 02 24 24@

    Se'%&% 12

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    62/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    63/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    64/293

    Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&% Se'%&% 4100 10? 105 @@ 10> @6

    Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&% Se'%&% 4

    2@2 261 264 265 261 256

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    65/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    66/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    67/293

    Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10@6 10> ?? @@ 121 11

    Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10

    254 04 2?1 41 02 0

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    68/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    69/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    70/293

    Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&% Se'%&% 4@> ?6 101 100 @6 116

    Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&% Se'%&% 4

    24 44 11 2>1 20 05

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    71/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    72/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    73/293

    Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10104 102 @@ 114 101 ??

    Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10

    2 2 2@ 24 11 24

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    74/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    75/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    76/293

    Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&% Se'%&% 4@4 100 110 106 105 ?6

    Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&% Se'%&% 4

    2? 55 1> 20 12 41

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    77/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    78/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    79/293

    Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10@@ 104 11 100 @5 100

    Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10

    50 64 10 2?@ 56 1

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    80/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    81/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    82/293

    Se'%&% 11 Se'%&% 1210 115

    Se'%&% 11 Se'%&% 12

    42 0?

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    83/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    84/293

    P%!'-&e #e ,-/-'!%$e&!- " 'e,"e&,$%

    Al 'e%l$(%' el %&%l$$ #e l% #e%% 8$!-'$,%7 &- /e'$!$- !e&e

    e%&% 27 l% e!%,$-&%l$#%# #e e!- e /'ee&!- ,-& "&% e

    P%'% l% e)"% 'ee'e&,$% &- e e&,-&!'%'-& ,-/-'!%$e&!- ,$,

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    85/293

    ' "&% $$-& % %/l$% #e l- #%!- 8$!-'$,- %/l$%7e&,-&!'%- -l- "& /%!'

    %,$-&%l$#%# #e "& %-.

    l-7 /-' el ,-&!'%'$- e e&,-&!'%'-& %'$%,$-&e $''e)"l%'e.

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    86/293

    -& ,$,l$,- e& el e!'e 2

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    87/293

    Los mestodos de pronostico propuesto son:

    Promedio movil : e ,%l,"l% % !'%; #e l% "l!$/l$

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    88/293

    %,$

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    89/293

    el &e'- #e #% #el /'-e#$-

    $!e ,%l,"l%' el /'-e#$- #e "&% e'$e

    /-#e- !'%%3%' ,-& l- #- % ="e

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    90/293

    Re=erencia

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    91/293

    P'-&-!$,- %&!e'$-' HF!1#e%% 'e%l HA!1E''-' #el /'-&

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    92/293

    56>?@

    101112

    TOTALES

    Pol+ticas la,orales

    SALARIO MINIMOCAPACITACION DE UN OPERARIO NUEVO

    SEMANA ORASDIAS ABILESDIAS NORMALES DEL MES

    ORAS ETRASORAS DIARIASEMPLEADOS FI9OS HNO SE PUEDEN DESPEDIRNO SE PERMITEN FALTANTES O ENTREGAS TARDIAS

    costos so,re la empresa

    COSTO DE ALMACENAMIENTOCOSTO MATERIALCOSTO DE SUB CONTRATACION HNO INCLUYE MATERIALES

    Plan de producci$n

    Cuanto puede producir un solo operario.

    SEMANADIAS ABILES LUNES A VIERNES

    TIEMPO EN PRODUCIR UNA UNIDADCUANTAS UNIDADES POR DIA

    OPERARIOS FI9OS JUE SE NECESITARIANEMPLEADOS FI9OS YA CONTRATADOS HNO SE PUEDEN DESPEDIR

    APROIMACION OPERARIOSECESO OPERARIO JUE SE NECESITAECESO OPERARIO JUE YA SE ENCUENTRAN FI9OS

    Mes

    124

    -oras

    MESES

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    93/293

    56>?@

    101112

    T/TALES

    COSTO DE ALMACENAMIENTO1245

    6>?@101112

    TOTALESCOSTO MATERIAL12

    456>?@101112

    TOTALES

    COSTO DE SUB CONTRATACION12456>?

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    94/293

    @101112

    TOTALES

    COSTO OPERACIONAL

    CANTIDAD DE OPERARIOSORAS DIARIASDIAS NORMALES

    CUANTOS DIAS TOTALESSALARIO MINIMO OPERARIOCOSTO DE CADA ORA POR OPERARIO

    TOTAL COSTO

    SUMA DE TODOS LOS COSTES

    CUANT/ C/STAR)A S) SE SUC/NTRATARA T// .

    Mes

    124

    56>?@

    101112

    T/TALES

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    95/293

    !'$e!'e 1 !'$e!'e 2 !'$e!'e !'$e!'e 4

    105 102 105 101101 @@ @@ 100106 100 10> @610? 10@ @6 116@1 102 @6 104

    101 @@ 10> 102

    100 11 ?? @@101 @6 @@ 11410@ 104 121 10110? @@ 11 ???? 100 @> @4

    100 10? ?6 100

    Se'%&% 1 Se'%&% 2 Se'%&% Se'%&% 4105.00 101.00 10.00 10.50

    105 101 106 10?0 0 4.5

    0.1 0.1 0.1 0.10 0 0. 0.45

    105.00 101.00 10.0 10.@5

    Se'%&% 1 Se'%&% 2 Se'%&% Se'%&% 4

    @4.00 101.00 100.50 @@.50102 @@ 100 10@

    ? 2 0.5 @.50.1 0.1 0.1 0.10.? 0.2 0.05 0.@5

    @4.?0 100.?0 100.45 100.45

    Se'%&% 1 Se'%&% 2 Se'%&% Se'%&% 4

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    96/293

    104.00 106.50 102.00 10.00105 @@ 10> @6

    1 >.5 5 >0.1 0.1 0.1 0.10.1 0.>5 0.5 0.>

    104.10 105.>5 102.50 102.0

    Se'%&% 1 Se'%&% 2 Se'%&% Se'%&% [email protected] @.50 100.50 @?.00

    101 100 @6 [email protected] 6.5 4.5 1?0.1 0.1 0.1 0.1

    0.@5 0.65 0.45 1.?

    @2.45 @4.15 100.05 @@.?0

    Se'%&% 1 Se'%&% 2 Se'%&% Se'%&% 4@>.00 105.00 10?.00 105.50

    110 106 105 ?61 1 [email protected]

    0.1 0.1 0.1 0.11. 0.1 0. 1.@5

    @?.0 105.10 10>.>0 10.55

    Se'%&% 1 Se'%&% 2 Se'%&% Se'%&% [email protected] 112.00 110.50 [email protected] 112.00 110.50 111.25

    0 0 0 00.1 0.1 0.1 0.1

    0 0 0 0

    [email protected] 112.00 110.50 111.25

    PLANT)LLA !)2A

    ias La,orales

    [email protected] 5112.00 5110.50 5111.25 5

    Pronostico#

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    97/293

    110.?? 5111.06 5110.@> 5111.02 5110.@@ 5111.00 5111.00 5111.00 511 60

    K 172507000K 171007000

    0.40

    520

    SOLO DOMINGOS?6

    K 17500K 607250

    K 57?00

    22

    408-'%?#$%

    0./-' 8-'%26.>"&$#%#e

    0.?6

    10.1>5.1>

    emanda Esperad ias La,orales PR/UCC)/N ST/C3 )N)C)AL

    10@ 5 1 0112 5 1 24111 5 1 46111 5 1 6@

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    98/293

    111 5 1 @1111 5 1 11111 5 1 15111 5 1 15?111 5 1 1?0111 5 1 202111 5 1 225111 5 1 24>

    1661 >0 1>00

    K 1?7250K 527500K ?57625

    K 11@71K 1527>1@

    K 1?67266K 21@7>42K 257254K 2?67>4?K 207251K 57>50K ?>7250

    K 2745766>

    K ?707K ?707

    K ?707K ?707K ?707K ?707K ?707K ?707K ?707K ?707K ?707K ?707

    K @674007000

    K 0K 0K 0K 0K 0K 0K 0K 0

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    99/293

    K 0K 0K 0K 0

    K

    1 6? ?

    20 2060 60

    K 172507000 K 172507000K >7?1 K >7?1

    K 7>507000.00 K 2275007000

    K 10275?57666.>5 K 12175766>

    emanda Esperad T/TAL C/ST/

    10@ K 627200 K 6756>7250 K >71@@7450112 K 64@7600 K 67>4?7000 K >7@>7600111 K 6407@00 K 6765>7625 K >72@?7525111 K 6457250 K 67>027?1 K >74?706

    111 K 6470>5 K 676?0721@ K >7272@4111 K 644716 K 676@17516 K >7576>?111 K 64761@ K 676?57?6> K >72@74?6111 K 647?@1 K 676??76@1 K >7275?2111 K 647>55 K 676?>72>@ K >71704111 K 647?2 K 676?>7@?5 K >717?0?111 K 647>?@ K 676?>762 K >717421111 K 647?06 K 676?>7?0@ K >717615

    1661 K >7>1>7?6@ K ?071>276?6 K ?>7?@07555

    OPERARIOS JUE SENECESITAN OPERARIOS CON LOS JUE SEDEBE TRABA9AR

    C/ST/ E LASUC/NTRATAC)/N

    C/ST/ EMATER)ALES

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    100/293

    !'$e!'e 5

    110 10106 10105 105

    ?6 106@@ 106

    104 104

    11 105100 105

    @5 105100 10510 105115 105

    Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 1010>.00 @@.50 @6.00 100.50 100.50 105.00

    @1 101 100 101 10@ 10?16 1.5 4 0.5 ?.5 0.1 0.1 0.1 0.1 0.1 0.1

    1.6 0.15 0.4 0.05 0.?5 0.

    105.40 @@.65 @6.40 100.55 101.5 105.0

    Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10

    104.50 105.50 100.50 106.00 104.50 100.00102 @@ 11 @6 104 @@2.5 6.5 12.5 10 0.5 10.1 0.1 0.1 0.1 0.1 0.1

    0.25 0.65 1.25 1 0.05 0.1

    104.25 104.?5 101.>5 105.00 104.45 @@.@0

    Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10

    De%&%#%Y! &5

    PRONOSTICO

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    101/293

    101.50 @6.00 101.50 @>.50 @.50 110.00@6 10> ?? @@ 121 11

    5.5 11 1.5 1.5 2>.5 0.1 0.1 0.1 0.1 0.1 0.1

    0.55 1.1 1.5 0.15 2.>5 0.

    100.@5 @>.10 100.15 @>.65 @6.25 110.0

    Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10106.00 110.00 10.00 100.50 106.50 10>.50

    104 102 @@ 114 101 ??2 ? 4 1.5 5.5 [email protected]

    0.1 0.1 0.1 0.1 0.1 0.10.2 0.? 0.4 1.5 0.55 1.@5

    105.?0 [email protected] 102.60 101.?5 105.@5 105.55

    Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @ Se'%&% [email protected] @2.50 101.50 10?.50 106.50 @>.50

    @@ 104 11 100 @5 100.5 11.5 11.5 ?.5 11.5 2.50.1 0.1 0.1 0.1 0.1 0.1

    0.5 1.15 1.15 0.?5 1.15 0.25

    @5.?5 @.65 102.65 10>.65 105.5 @>.>5

    Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10110.?? 111.06 110.@> 111.02 110.@@ 111.00110.?? 111.06 110.@> 111.02 110.@@ 111.00

    0 0 0 0 0 00.1 0.1 0.1 0.1 0.1 0.1

    0 0 0 0 0 0

    110.?? 111.06 110.@> 111.02 110.@@ 111.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    102/293

    T/C3 !)NA T/C3 ME) ,contratacion

    24 12 046 5 06@ 5> 0@1 ?0 0

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    103/293

    11 102 015 124 015? 146 01?0 16@ 0202 1@1 0225 214 024> 26 026@ 25? 0

    1>; 0

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    104/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    105/293

    Se'%&% 11 Se'%&% 1210?.50 @?.00

    ?? 10020.5 2

    0.1 0.12.05 0.2

    106.45 @?.20

    Se'%&% 11 Se'%&% 12

    101.50 @@.50100 10?1.5 ?.50.1 0.1

    0.15 0.?5

    101.5 100.5

    Se'%&% 11 Se'%&% 12

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    106/293

    11>.00 105.00@> ?6

    20 [email protected] 0.12 1.@

    115.00 10.10

    Se'%&% 11 Se'%&% [email protected] @1.00

    @4 1000.5 @0.1 0.1

    0.05 0.@

    @4.45 @1.@0

    Se'%&% 11 Se'%&% 12@>.50 101.50

    10 1155.5 1.50.1 0.1

    0.55 1.5

    @?.05 102.?5

    Se'%&% 11 Se'%&% 12111.00 111.00111.00 111.00

    0 00.1 0.1

    0 0

    111.00 111.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    107/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    108/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    109/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    110/293

    NIVEL 0

    NIVEL 1 C

    NIVEL 2

    Re=erencia

    1.00 C206P

    2.00

    .00

    4.00

    L200E

    e%&% Se'%&% 1 Se'%&% 2#e%% 105.00 101.00

    NIVEL 0P'-#",!-

    L200E

    NIVEL 1 P'-#",!-

    C206P

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    111/293

    NIVEL 2

    MATER)

    P'-#",!-

    C206P

    NIVEL 0

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    112/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    113/293

    DIAGRAMA DE ARBOL

    L20

    0>P .00 L222P

    L22F

    Se'%&% Se'%&% 4 Se'%&% 5106.00 10?.00 @1.00

    Le%# T$e S!-, #e e)"'$#%# Re,e/,$-&e /e$e&!e

    1.00 0.00

    C0>P

    Le%# T$e S!-, #e e)"'$#%# Re,e/,$-&e /e$e&!e

    1.00 0.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    114/293

    ALES E LA RE!ERENC)A C0>P

    Le%# T$e S!-, #e e)"'$#%# Re,e/,$-&e /e$e&!e

    1.00 0.00

    ">700 "5700 ";700

    ">700 "5700 ";700

    ">700 "5700 ";700

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    115/293

    ">700 "5700 ";700

    ">700 "5700 ";700

    ">700 "5700 ";700

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    116/293

    0E

    A Se'%&% ? Se'%&% @

    101.00 100.00 101.00 [email protected]

    0.00L-!e % l-!e

    150.00 L-!e % l-!e

    D$/-&$$l$#%# e& el%l%,;&

    M;!-#- #e ,*l,"l- #el- l-!e

    D$/-&$$l$#%# e& el%l%,;&

    M;!-#- #e ,*l,"l- #el- l-!e

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    117/293

    unidades

    150.00 L-!e % l-!e 4.00

    /e

    "6700 "700 "1700 Se'%&% 1

    105.000.00 0.00

    0.000.00

    105.00105.00

    105.00 101.00

    "6700 "700 "1700 Se'%&% 1

    105.00150.00 0.00

    0.000.00

    15.0015.00

    15.00 101.00 101.00

    "6700 "700 "1700 Se'%&% 1105.00

    10.00 0.000.000.00

    @[email protected]

    @5.00 101.00 @6.00 101.00

    D$/-&$$l$#%# e& el%l%,;&

    M;!-#- #e ,*l,"l- #el- l-!e

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    118/293

    "6700 "700 "1700 Se'%&% 1

    105.0015.00 15.00

    15.000.00

    105.00105.00

    111.00 11.00 @6.00 101.00

    "6700 "700 "1700 Se'%&% 1

    10.00150.00 0.00

    0.00

    0.0010.0010.00

    10.00 606.00 606.00

    "6700 "700 "1700 Se'%&% 1

    @5.000.00 20.00

    20.000.00

    ?5.00?5.00

    ?5.00 606.00 606.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    119/293

    Se'%&% 10 Se'%&% 11 Se'%&% 1210?.00 ??.00 100.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    120/293

    MATER)ALES E LA RE!ERENC)A

    P'-#",!- Le%# T$e S!-, #e e)"'$#%#

    C206P 1.00 0.00

    C10P 1.00 20.00L222P 4.00 10.00

    L22F 1.00 0.00

    Se'%&% 2 Se'%&% Se'%&% 4

    101.00 106.00 10?.005.00 5.00 5.000.00 0.00 0.000.00 0.00 0.00

    101.00 101.00 10.00101.00 101.00 10.00101.00 10.00 ?6.00

    Se'%&% 2 Se'%&% Se'%&% 4

    101.00 101.00 10.005.00 5.00 5.00

    0.00 0.00 0.000.00 0.00 0.00

    101.00 126.00 12?.00101.00 126.00 12?.00126.00 12?.00 111.00

    Se'%&% 2 Se'%&% Se'%&% 4101.00 101.00 10.00

    5.00 5.00 5.000.00 0.00 0.000.00 0.00 0.00

    101.00 @6.00 @?.00101.00 @6.00 @[email protected] @?.00 ?1.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    121/293

    Se'%&% 2 Se'%&% Se'%&% 4

    101.00 101.00 10.005.00 5.00 5.00

    15.00 15.00 15.000.00 0.00 0.00

    101.00 111.00 11.00101.00 111.00 11.00111.00 11.00 @6.00

    Se'%&% 2 Se'%&% Se'%&% 4

    606.00 [email protected] >0?.005.00 5.00 5.00

    0.00 0.00 0.00

    0.00 0.00 0.00606.00 >21.00 >.00606.00 >21.00 >.00>21.00 >.00 61.00

    Se'%&% 2 Se'%&% Se'%&% 4

    606.00 606.00 61?.005.00 5.00 5.00

    20.00 20.00 20.000.00 0.00 0.00

    606.00 621.00 6.00606.00 621.00 6.00621.00 6.00 51.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    122/293

    P'-#",!- Le%# T$e

    C206P 1.00 0.00

    C10P 1.00 20.00

    L200E 1.00 0.00

    L211A 2.00 0.00

    L212P 2.00 15.00L222P 4.00 10.00

    L22F 1.00 0.00

    SL100E 1.00 0.00

    SL111P 2.00 0.00

    SL112A .00 5.00

    SL11P 1.00 20.00

    SL121F .00 0.00

    SL122A 1.00 0.00

    SL12A 1.00 0.00

    SL11F 2.00 0.00

    SL12P 1.00 25.00

    SL1F 2.00 0.00

    SL14P 1.00 25.00

    Se'%&% 1 Se'%&% 2 Se'%&% 102.00 @@.00 100.00

    11A

    Re,e/,$-&e /e$e&!e

    >0 H6 !'$ e 2 10.00 L-!e % l-!e

    S!-, #ee)"'$#%#

    D$/-&$$l$#%# e& el%l%,;&

    M;!-#- #e,*l,"l- #e l-

    l-!e

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    123/293

    0.00 L-!e % l-!e

    !'$e!'e 1

    Se'%&% 5 Se'%&% 6 Se'%&% >

    @1.00 101.00 100.005.00 5.00 5.000.00 0.00 0.000.00 0.00 0.00

    ?6.00 @6.00 @5.00?6.00 @6.00 @[email protected] @5.00 @6.00

    !'$e!'e 1Se'%&% 5 Se'%&% 6 Se'%&% >

    ?6.00 @6.00 @5.005.00 5.00 5.00

    0.00 0.00 0.000.00 0.00 0.00

    111.00 121.00 120.00111.00 121.00 120.00121.00 120.00 121.00

    !'$e!'e 1

    Se'%&% 5 Se'%&% 6 Se'%&% >?6.00 @6.00 @5.00

    5.00 5.00 5.000.00 0.00 0.000.00 0.00 0.00

    ?1.00 @1.00 @0.00?1.00 @1.00 @[email protected] @0.00 @1.00

    D$/-&$$l$#%# e& el%l%,;&

    M;!-#- #e,*l,"l- #e l-

    l-!e

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    124/293

    !'$e!'e 1

    Se'%&% 5 Se'%&% 6 Se'%&% >

    ?6.00 @6.00 @5.005.00 5.00 5.00

    15.00 15.00 15.000.00 150.00 0.00

    @6.00 44.00 [email protected] 44.00 105.0044.00 105.00 106.00

    !'$e!'e 1

    Se'%&% 5 Se'%&% 6 Se'%&% >

    606.00 666.00 660.005.00 5.00 5.00

    0.00 0.00 0.00

    0.00 0.00 0.0061.00 [email protected] 6?5.0061.00 [email protected] [email protected] 6?5.00 [email protected]

    !'$e!'e 1

    Se'%&% 5 Se'%&% 6 Se'%&% >

    516.00 2>6.00 5>0.005.00 5.00 5.00

    20.00 20.00 20.000.00 0.00 0.00

    51.00 [email protected] 5?5.0051.00 [email protected] [email protected] 5?5.00 [email protected]

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    125/293

    150.00 L-!e % l-!e

    240 H6 !'$ e 2 0.00 L-!e % l-!e

    0.00 L-!e % l-!e

    >0 H6 !'$ e 2 10.00 L-!e % l-!e

    15.00 L-!e % l-!e140 HH6 !'$ e 4 50.00 L-!e % l-!e

    >0.00 L-!e % l-!e

    5.00 L-!e % l-!e

    15.00 L-!e % l-!e

    10 H6 !'$ e 20.00 L-!e % l-!e

    20.00 L-!e % l-!e

    @0 H6 !'$ e 0.00 L-!e % l-!e

    >5 H6 !'$ e 2 10.00 L-!e % l-!e

    10.00 L-!e % l-!e

    0.00 L-!e % l-!e

    150 H6 !'$ e 2 40.00 L-!e % l-!e

    240 H6 !'$ e 2 0.00 L-!e % l-!e

    150 H6 !'$ e 1 20.00 L-!e % l-!e

    !'$e!'e 2Se'%&% 4 Se'%&% 5 Se'%&% 6

    [email protected] 102.00 @@.00

    P'-#",!- Le%# T$e

    L212P 2.00

    Re,e/,$-&e/e$e&!e

    D$/-&$$l$#%# e& el%l%,;&

    M;!-#- #e ,*l,"l- #el- l-!e

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    126/293

    MATER)AL

    unidades P'-#",!-

    2.00 L212P

    1.001.00

    1.00

    Se'%&% ? Se'%&% @ Se'%&% 10

    101.00 [email protected] 10?.005.00 5.00 5.000.00 0.00 0.000.00 0.00 0.00

    @6.00 104.00 [email protected] 104.00 10.00

    104.00 10.00 ?.00

    Se'%&% ? Se'%&% @ Se'%&% 10

    @6.00 104.00 10.005.00 5.00 5.00

    0.00 0.00 0.000.00 0.00 0.00

    121.00 [email protected] 12?.00121.00 [email protected] [email protected] 12?.00 10?.00

    Se'%&% ? Se'%&% @ Se'%&% [email protected] 104.00 10.00

    5.00 5.00 5.000.00 0.00 0.000.00 0.00 0.00

    @1.00 @@.00 @[email protected] @@.00 @?.00@@.00 @?.00 >?.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    127/293

    Se'%&% ? Se'%&% @ Se'%&% 10

    @6.00 104.00 10.005.00 5.00 5.00

    15.00 15.00 15.000.00 0.00 0.00

    106.00 114.00 11.00106.00 114.00 11.00114.00 11.00 @.00

    Se'%&% ? Se'%&% @ Se'%&% 10

    666.00 >14.00 >0?.005.00 5.00 5.00

    0.00 0.00 0.00

    0.00 0.00 [email protected] >@.00 >[email protected] >@.00 >.00>@.00 >.00 61.00

    Se'%&% ? Se'%&% @ Se'%&% 10

    5>6.00 624.00 61?.005.00 5.00 5.00

    20.00 20.00 20.000.00 0.00 0.00

    [email protected] [email protected] [email protected] [email protected] [email protected] 6.00 51.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    128/293

    Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10 Se'%&% 1111.00 @6.00 104.00 @@.00 100.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    129/293

    S E LA RE!ERENC)A L212P

    Le%# T$e

    2.00 15.00 15.00 L-!e % l-!e

    Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    ??.00 100.00 102.00 @@.00 100.005.00 5.00 5.00 5.00 5.000.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00?.00 @5.00 @>.00 @4.00 @5.00?.00 @5.00 @>.00 @4.00 @[email protected] @>.00 @4.00 @5.00 104.00

    Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    ?.00 @5.00 @>.00 @4.00 @5.005.00 5.00 5.00 5.00 5.000.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00

    10?.00 120.00 122.00 [email protected] 120.0010?.00 120.00 122.00 [email protected] 120.00120.00 122.00 [email protected] 120.00 [email protected]

    Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&% ?.00 @5.00 @>.00 @4.00 @5.00

    5.00 5.00 5.00 5.00 5.000.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00>?.00 @0.00 @2.00 [email protected] @0.00>?.00 @0.00 @2.00 [email protected] @[email protected] @2.00 [email protected] @0.00 @@.00

    S!-, #ee)"'$#%#

    Re,e/,$-&e/e$e&!e

    D$/-&$$l$#%#e& el %l%,;&

    M;!-#- #e ,*l,"l-#e l- l-!e

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    130/293

    Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    ?.00 @5.00 @>.00 @4.00 @5.005.00 5.00 5.00 5.00 5.0015.00 15.00 15.00 15.00 15.000.00 0.00 0.00 0.00 0.00

    @.00 105.00 10>.00 104.00 [email protected] 105.00 10>.00 104.00 105.00

    105.00 10>.00 104.00 105.00 114.00

    Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    5??.00 660.00 6>2.00 654.00 660.005.00 5.00 5.00 5.00 5.000.00 0.00 0.00 0.00 0.00

    0.00 0.00 0.00 0.00 0.0061.00 6?5.00 6@>.00 6>@.00 6?5.0061.00 6?5.00 6@>.00 6>@.00 6?5.006?5.00 6@>.00 6>@.00 6?5.00 >@.00

    Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    4@?.00 5>0.00 5?2.00 564.00 5>0.005.00 5.00 5.00 5.00 5.0020.00 20.00 20.00 20.00 20.000.00 0.00 0.00 0.00 0.00

    51.00 5?5.00 5@>.00 5>@.00 5?5.0051.00 5?5.00 5@>.00 5>@.00 5?5.005?5.00 5@>.00 5>@.00 5?5.00 [email protected]

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    131/293

    Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&% Se'%&% 4 Se'%&% 510?.00 105.00 @@.00 10>.00 @6.00 @6.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    132/293

    unidades

    1.00

    !'$e!'e 2

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    [email protected] 102.00 @@.00 11.00 @6.00 104.005.00 5.00 5.00 5.00 5.00 5.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    104.00 @>.00 @4.00 10?.00 @1.00 @@.00104.00 @>.00 @4.00 10?.00 @1.00 @@.00@>.00 @4.00 10?.00 @1.00 @@.00 @4.00

    !'$e!'e 2Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    104.00 @>.00 @4.00 10?.00 @1.00 @@.005.00 5.00 5.00 5.00 5.00 5.00

    0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    [email protected] 122.00 [email protected] 1.00 116.00 [email protected] 122.00 [email protected] 1.00 116.00 124.00122.00 [email protected] 1.00 116.00 124.00 [email protected]

    !'$e!'e 2

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @104.00 @>.00 @4.00 10?.00 @1.00 @@.00

    5.00 5.00 5.00 5.00 5.00 5.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    @@.00 @2.00 [email protected] 10.00 ?6.00 @4.00@@.00 @2.00 [email protected] 10.00 ?6.00 @[email protected] [email protected] 10.00 ?6.00 @4.00 [email protected]

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    133/293

    !'$e!'e 2

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    104.00 @>.00 @4.00 10?.00 @1.00 @@.005.00 5.00 5.00 5.00 5.00 5.00

    15.00 15.00 15.00 15.00 15.00 15.000.00 0.00 0.00 0.00 0.00 0.00

    114.00 10>.00 104.00 11?.00 101.00 [email protected] 10>.00 104.00 11?.00 101.00 [email protected]>.00 104.00 11?.00 101.00 [email protected] 104.00

    !'$e!'e 2

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    >14.00 6>2.00 654.00 >?.00 66.00 6?4.005.00 5.00 5.00 5.00 5.00 5.00

    0.00 0.00 0.00 0.00 0.00 0.00

    0.00 0.00 0.00 0.00 0.00 0.00>@.00 6@>.00 6>@.00 >6.00 661.00 >[email protected]>@.00 6@>.00 6>@.00 >6.00 661.00 >[email protected]@>.00 6>@.00 >6.00 661.00 >[email protected] 6>@.00

    !'$e!'e 2

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    624.00 5?2.00 564.00 64?.00 546.00 [email protected] 5.00 5.00 5.00 5.00 5.00

    20.00 20.00 20.00 20.00 20.00 20.000.00 0.00 0.00 0.00 0.00 0.00

    [email protected] 5@>.00 5>@.00 66.00 561.00 [email protected]@.00 5@>.00 5>@.00 66.00 561.00 [email protected]@>.00 5>@.00 66.00 561.00 [email protected] 5>@.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    134/293

    !'$e!'e Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10 Se'%&% 11

    10>.00 ??.00 @@.00 121.00 11.00 @>.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    135/293

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    @@.00 100.00 10?.00 105.00 @@.00 10>.005.00 5.00 5.00 5.00 5.00 5.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    @4.00 @5.00 10.00 100.00 @4.00 [email protected] @5.00 10.00 100.00 @4.00 [email protected] 10.00 100.00 @4.00 102.00 @1.00

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    @4.00 @5.00 10.00 100.00 @4.00 102.005.00 5.00 5.00 5.00 5.00 5.00

    0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    [email protected] 120.00 12?.00 125.00 [email protected] 12>[email protected] 120.00 12?.00 125.00 [email protected] 12>.00120.00 12?.00 125.00 [email protected] 12>.00 116.00

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&% @4.00 @5.00 10.00 100.00 @4.00 102.00

    5.00 5.00 5.00 5.00 5.00 5.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    [email protected] @0.00 @?.00 @5.00 [email protected] @>[email protected] @0.00 @?.00 @5.00 [email protected] @>[email protected] @?.00 @5.00 [email protected] @>.00 ?6.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    136/293

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    @4.00 @5.00 10.00 100.00 @4.00 102.005.00 5.00 5.00 5.00 5.00 5.00

    15.00 15.00 15.00 15.00 15.00 15.000.00 0.00 0.00 0.00 0.00 0.00

    104.00 105.00 11.00 110.00 104.00 112.00104.00 105.00 11.00 110.00 104.00 112.00105.00 11.00 110.00 104.00 112.00 101.00

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    654.00 660.00 >0?.00 [email protected] 654.00 >02.005.00 5.00 5.00 5.00 5.00 5.00

    0.00 0.00 0.00 0.00 0.00 0.00

    0.00 0.00 0.00 0.00 0.00 0.006>@.00 6?5.00 >.00 >15.00 6>@.00 >2>.006>@.00 6?5.00 >.00 >15.00 6>@.00 >2>.006?5.00 >.00 >15.00 6>@.00 >2>.00 661.00

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    564.00 5>0.00 61?.00 600.00 564.00 612.005.00 5.00 5.00 5.00 5.00 5.00

    20.00 20.00 20.00 20.00 20.00 20.000.00 0.00 0.00 0.00 0.00 0.00

    5>@.00 5?5.00 6.00 615.00 5>@.00 62>.005>@.00 5?5.00 6.00 615.00 5>@.00 62>.005?5.00 6.00 615.00 5>@.00 62>.00 561.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    137/293

    Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&% Se'%&% 4 Se'%&% 5?6.00 101.00 100.00 @6.00 116.00 104.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    138/293

    !'$e!'e

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    @6.00 @6.00 10>.00 ??.00 @@.00 121.005.00 5.00 5.00 5.00 5.00 5.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    @1.00 @1.00 102.00 ?.00 @4.00 [email protected] @1.00 102.00 ?.00 @4.00 [email protected] 102.00 ?.00 @4.00 116.00 10?.00

    !'$e!'e Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    @1.00 @1.00 102.00 ?.00 @4.00 116.005.00 5.00 5.00 5.00 5.00 5.00

    0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    116.00 116.00 12>.00 10?.00 [email protected] 141.00116.00 116.00 12>.00 10?.00 [email protected] 141.00116.00 12>.00 10?.00 [email protected] 141.00 1.00

    !'$e!'e

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @@1.00 @1.00 102.00 ?.00 @4.00 116.00

    5.00 5.00 5.00 5.00 5.00 5.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    ?6.00 ?6.00 @>.00 >?.00 [email protected] 111.00?6.00 ?6.00 @>.00 >?.00 [email protected] 111.00?6.00 @>.00 >?.00 [email protected] 111.00 10.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    139/293

    !'$e!'e

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    @1.00 @1.00 102.00 ?.00 @4.00 116.005.00 5.00 5.00 5.00 5.00 5.00

    15.00 15.00 15.00 15.00 15.00 15.000.00 0.00 0.00 0.00 0.00 0.00

    101.00 101.00 112.00 @.00 104.00 126.00101.00 101.00 112.00 @.00 104.00 126.00101.00 112.00 @.00 104.00 126.00 11?.00

    !'$e!'e

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    66.00 66.00 >02.00 5??.00 654.00 >?6.005.00 5.00 5.00 5.00 5.00 5.00

    0.00 0.00 0.00 0.00 0.00 0.00

    0.00 0.00 0.00 0.00 0.00 0.00661.00 661.00 >2>.00 61.00 6>@.00 ?11.00661.00 661.00 >2>.00 61.00 6>@.00 ?11.00661.00 >2>.00 61.00 6>@.00 ?11.00 >6.00

    !'$e!'e

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    546.00 546.00 612.00 4@?.00 564.00 [email protected] 5.00 5.00 5.00 5.00 5.00

    20.00 20.00 20.00 20.00 20.00 20.000.00 0.00 0.00 0.00 0.00 0.00

    561.00 561.00 62>.00 51.00 5>@.00 >11.00561.00 561.00 62>.00 51.00 5>@.00 >11.00561.00 62>.00 51.00 5>@.00 >11.00 66.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    140/293

    !'$e!'e 4Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10 Se'%&% 11

    102.00 @@.00 114.00 101.00 ??.00 @4.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    141/293

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    11.00 @>.00 ?6.00 101.00 100.00 @6.005.00 5.00 5.00 5.00 5.00 5.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    10?.00 @2.00 ?1.00 @6.00 @5.00 @1.0010?.00 @2.00 ?1.00 @6.00 @5.00 @[email protected] ?1.00 @6.00 @5.00 @1.00 111.00

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    10?.00 @2.00 ?1.00 @6.00 @5.00 @1.005.00 5.00 5.00 5.00 5.00 5.00

    0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    1.00 11>.00 106.00 121.00 120.00 116.001.00 11>.00 106.00 121.00 120.00 116.0011>.00 106.00 121.00 120.00 116.00 16.00

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&% 10?.00 @2.00 ?1.00 @6.00 @5.00 @1.00

    5.00 5.00 5.00 5.00 5.00 5.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    10.00 ?>.00 >6.00 @1.00 @0.00 ?6.0010.00 ?>.00 >6.00 @1.00 @0.00 ?6.00?>.00 >6.00 @1.00 @0.00 ?6.00 106.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    142/293

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    10?.00 @2.00 ?1.00 @6.00 @5.00 @1.005.00 5.00 5.00 5.00 5.00 5.00

    15.00 15.00 15.00 15.00 15.00 15.000.00 0.00 0.00 0.00 0.00 0.00

    11?.00 102.00 @1.00 106.00 105.00 101.0011?.00 102.00 @1.00 106.00 105.00 101.00102.00 @1.00 106.00 105.00 101.00 121.00

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    >?.00 642.00 5>6.00 666.00 660.00 66.005.00 5.00 5.00 5.00 5.00 5.00

    0.00 0.00 0.00 0.00 0.00 0.00

    0.00 0.00 0.00 0.00 0.00 0.00>6.00 66>.00 601.00 [email protected] 6?5.00 661.00>6.00 66>.00 601.00 [email protected] 6?5.00 661.0066>.00 601.00 [email protected] 6?5.00 661.00 >?1.00

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    64?.00 552.00 4?6.00 5>6.00 5>0.00 546.005.00 5.00 5.00 5.00 5.00 5.00

    20.00 20.00 20.00 20.00 20.00 20.000.00 0.00 0.00 0.00 0.00 0.00

    66.00 56>.00 501.00 [email protected] 5?5.00 561.0066.00 56>.00 501.00 [email protected] 5?5.00 561.0056>.00 501.00 [email protected] 5?5.00 561.00 6?1.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    143/293

    Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&% Se'%&% 4 Se'%&% 5100.00 110.00 106.00 105.00 ?6.00 @@.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    144/293

    !'$e!'e 4

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    116.00 104.00 102.00 @@.00 114.00 101.005.00 5.00 5.00 5.00 5.00 5.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    111.00 @@.00 @>.00 @4.00 [email protected] @6.00111.00 @@.00 @>.00 @4.00 [email protected] @6.00@@.00 @>.00 @4.00 [email protected] @6.00 ?.00

    !'$e!'e 4Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    111.00 @@.00 @>.00 @4.00 [email protected] @6.005.00 5.00 5.00 5.00 5.00 5.00

    0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    16.00 124.00 122.00 [email protected] 14.00 121.0016.00 124.00 122.00 [email protected] 14.00 121.00124.00 122.00 [email protected] 14.00 121.00 10?.00

    !'$e!'e 4

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @111.00 @@.00 @>.00 @4.00 [email protected] @6.00

    5.00 5.00 5.00 5.00 5.00 5.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    106.00 @4.00 @2.00 [email protected] 104.00 @1.00106.00 @4.00 @2.00 [email protected] 104.00 @[email protected] @2.00 [email protected] 104.00 @1.00 >?.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    145/293

    !'$e!'e 4

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    111.00 @@.00 @>.00 @4.00 [email protected] @6.005.00 5.00 5.00 5.00 5.00 5.00

    15.00 15.00 15.00 15.00 15.00 15.000.00 0.00 0.00 0.00 0.00 0.00

    121.00 [email protected] 10>.00 104.00 [email protected] 106.00121.00 [email protected] 10>.00 104.00 [email protected] [email protected] 10>.00 104.00 [email protected] 106.00 @.00

    !'$e!'e 4

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    >56.00 6?4.00 6>2.00 654.00 >44.00 666.005.00 5.00 5.00 5.00 5.00 5.00

    0.00 0.00 0.00 0.00 0.00 0.00

    0.00 0.00 0.00 0.00 0.00 0.00>?1.00 >[email protected] 6@>.00 6>@.00 >[email protected] [email protected]>?1.00 >[email protected] 6@>.00 6>@.00 >[email protected] [email protected]>[email protected] 6@>.00 6>@.00 >[email protected] [email protected] 61.00

    !'$e!'e 4

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    666.00 [email protected] 5?2.00 564.00 654.00 5>6.005.00 5.00 5.00 5.00 5.00 5.00

    20.00 20.00 20.00 20.00 20.00 20.000.00 0.00 0.00 0.00 0.00 0.00

    6?1.00 [email protected] 5@>.00 5>@.00 [email protected] [email protected]?1.00 [email protected] 5@>.00 5>@.00 [email protected] [email protected]@.00 5@>.00 5>@.00 [email protected] [email protected] 51.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    146/293

    !'$e!'e 5Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10 Se'%&% 11

    104.00 11.00 100.00 @5.00 100.00 10.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    147/293

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    ??.00 @4.00 100.00 110.00 106.00 105.005.00 5.00 5.00 5.00 5.00 5.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    ?.00 [email protected] @5.00 105.00 101.00 100.00?.00 [email protected] @5.00 105.00 101.00 [email protected] @5.00 105.00 101.00 100.00 ?1.00

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    ?.00 [email protected] @5.00 105.00 101.00 100.005.00 5.00 5.00 5.00 5.00 5.00

    0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    10?.00 114.00 120.00 10.00 126.00 125.0010?.00 114.00 120.00 10.00 126.00 125.00114.00 120.00 10.00 126.00 125.00 106.00

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&% ?.00 [email protected] @5.00 105.00 101.00 100.00

    5.00 5.00 5.00 5.00 5.00 5.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    >?.00 ?4.00 @0.00 100.00 @6.00 @5.00>?.00 ?4.00 @0.00 100.00 @6.00 @5.00?4.00 @0.00 100.00 @6.00 @5.00 >6.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    148/293

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    ?.00 [email protected] @5.00 105.00 101.00 100.005.00 5.00 5.00 5.00 5.00 5.00

    15.00 15.00 15.00 15.00 15.00 15.000.00 0.00 0.00 0.00 0.00 0.00

    @.00 @@.00 105.00 115.00 111.00 [email protected] @@.00 105.00 115.00 111.00 110.00@@.00 105.00 115.00 111.00 110.00 @1.00

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    5??.00 624.00 660.00 >20.00 [email protected] [email protected] 5.00 5.00 5.00 5.00 5.00

    0.00 0.00 0.00 0.00 0.00 0.00

    0.00 0.00 0.00 0.00 0.00 0.0061.00 [email protected] 6?5.00 >45.00 >21.00 >15.0061.00 [email protected] 6?5.00 >45.00 >21.00 >[email protected] 6?5.00 >45.00 >21.00 >15.00 601.00

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    4@?.00 54.00 5>0.00 60.00 606.00 600.005.00 5.00 5.00 5.00 5.00 5.00

    20.00 20.00 20.00 20.00 20.00 20.000.00 0.00 0.00 0.00 0.00 0.00

    51.00 [email protected] 5?5.00 645.00 621.00 615.0051.00 [email protected] 5?5.00 645.00 621.00 [email protected] 5?5.00 645.00 621.00 615.00 501.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    149/293

    Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&% Se'%&% 4 Se'%&% 5115.00 [email protected] 112.00 110.50 111.25 110.??

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    150/293

    !'$e!'e 5

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    ?6.00 @@.00 104.00 11.00 100.00 @5.005.00 5.00 5.00 5.00 5.00 5.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    ?1.00 @4.00 @@.00 10?.00 @5.00 @0.00?1.00 @4.00 @@.00 10?.00 @5.00 @[email protected] @@.00 10?.00 @5.00 @0.00 @5.00

    !'$e!'e 5Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    ?1.00 @4.00 @@.00 10?.00 @5.00 @0.005.00 5.00 5.00 5.00 5.00 5.00

    0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    106.00 [email protected] 124.00 1.00 120.00 115.00106.00 [email protected] 124.00 1.00 120.00 [email protected] 124.00 1.00 120.00 115.00 120.00

    !'$e!'e 5

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @?1.00 @4.00 @@.00 10?.00 @5.00 @0.00

    5.00 5.00 5.00 5.00 5.00 5.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    >6.00 [email protected] @4.00 10.00 @0.00 ?5.00>6.00 [email protected] @4.00 10.00 @0.00 [email protected] @4.00 10.00 @0.00 ?5.00 @0.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    151/293

    !'$e!'e 5

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    ?1.00 @4.00 @@.00 10?.00 @5.00 @0.005.00 5.00 5.00 5.00 5.00 5.00

    15.00 15.00 15.00 15.00 15.00 15.000.00 0.00 0.00 0.00 0.00 0.00

    @1.00 104.00 [email protected] 11?.00 105.00 [email protected] 104.00 [email protected] 11?.00 105.00 100.00

    104.00 [email protected] 11?.00 105.00 100.00 105.00

    !'$e!'e 5

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    5>6.00 654.00 6?4.00 >?.00 660.00 60.005.00 5.00 5.00 5.00 5.00 5.00

    0.00 0.00 0.00 0.00 0.00 0.00

    0.00 0.00 0.00 0.00 0.00 0.00601.00 6>@.00 >[email protected] >6.00 6?5.00 655.00601.00 6>@.00 >[email protected] >6.00 6?5.00 655.006>@.00 >[email protected] >6.00 6?5.00 655.00 6?5.00

    !'$e!'e 5

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    4?6.00 564.00 [email protected] 64?.00 5>0.00 540.005.00 5.00 5.00 5.00 5.00 5.00

    20.00 20.00 20.00 20.00 20.00 20.000.00 0.00 0.00 0.00 0.00 0.00

    501.00 5>@.00 [email protected] 66.00 5?5.00 555.00501.00 5>@.00 [email protected] 66.00 5?5.00 555.005>@.00 [email protected] 66.00 5?5.00 555.00 5?5.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    152/293

    !'$e!'e 6Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10 Se'%&% 11

    111.06 110.@> 111.02 110.@@ 111.00 111.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    153/293

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    100.00 10.00 115.00 [email protected] 112.00 110.505.00 5.00 5.00 5.00 5.00 5.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    @5.00 @?.00 110.00 104.00 10>.00 [email protected] @?.00 110.00 104.00 10>.00 105.50@?.00 110.00 104.00 10>.00 105.50 106.25

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    @5.00 @?.00 110.00 104.00 10>.00 105.505.00 5.00 5.00 5.00 5.00 5.00

    0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    120.00 12.00 15.00 [email protected] 12.00 10.50120.00 12.00 15.00 [email protected] 12.00 10.5012.00 15.00 [email protected] 12.00 10.50 11.25

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&% @5.00 @?.00 110.00 104.00 10>.00 105.50

    5.00 5.00 5.00 5.00 5.00 5.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    @0.00 @.00 105.00 @@.00 102.00 [email protected] @.00 105.00 @@.00 102.00 [email protected] 105.00 @@.00 102.00 100.50 101.25

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    154/293

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    @5.00 @?.00 110.00 104.00 10>.00 105.505.00 5.00 5.00 5.00 5.00 5.00

    15.00 15.00 15.00 15.00 15.00 15.000.00 0.00 0.00 0.00 0.00 0.00

    105.00 10?.00 120.00 114.00 11>.00 115.50105.00 10?.00 120.00 114.00 11>.00 115.5010?.00 120.00 114.00 11>.00 115.50 116.25

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    660.00 6>?.00 >50.00 >14.00 >2.00 >2.005.00 5.00 5.00 5.00 5.00 5.00

    0.00 0.00 0.00 0.00 0.00 0.00

    0.00 0.00 0.00 0.00 0.00 0.006?5.00 >0.00 >>5.00 >@.00 >5>.00 >4?.006?5.00 >0.00 >>5.00 >@.00 >5>.00 >4?.00>0.00 >>5.00 >@.00 >5>.00 >4?.00 >52.50

    Se'%&% 10 Se'%&% 11 Se'%&% 12 Se'%&% 1 Se'%&% 2 Se'%&%

    5>0.00 5??.00 660.00 624.00 642.00 6.005.00 5.00 5.00 5.00 5.00 5.00

    20.00 20.00 20.00 20.00 20.00 20.000.00 0.00 0.00 0.00 240.00 0.00

    5?5.00 60.00 6>5.00 [email protected] 41>.00 64?.005?5.00 60.00 6>5.00 [email protected] 41>.00 64?.0060.00 6>5.00 [email protected] 41>.00 64?.00 652.50

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    155/293

    Se'%&% 12

    111.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    156/293

    !'$e!'e 6

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    111.25 110.?? 111.06 110.@> 111.02 110.@@5.00 5.00 5.00 5.00 5.00 5.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    106.25 105.?? 106.06 105.@> 106.02 105.@@106.25 105.?? 106.06 105.@> 106.02 105.@@105.?? 106.06 105.@> 106.02 105.@@ 106.00

    !'$e!'e 6Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    106.25 105.?? 106.06 105.@> 106.02 105.@@5.00 5.00 5.00 5.00 5.00 5.00

    0.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    11.25 10.?? 11.06 10.@> 11.02 10.@@11.25 10.?? 11.06 10.@> 11.02 10.@@10.?? 11.06 10.@> 11.02 10.@@ 11.00

    !'$e!'e 6

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    106.25 105.?? 106.06 105.@> 106.02 105.@@5.00 5.00 5.00 5.00 5.00 5.000.00 0.00 0.00 0.00 0.00 0.000.00 0.00 0.00 0.00 0.00 0.00

    101.25 100.?? 101.06 100.@> 101.02 100.@@101.25 100.?? 101.06 100.@> 101.02 100.@@100.?? 101.06 100.@> 101.02 100.@@ 101.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    157/293

    !'$e!'e 6

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    106.25 105.?? 106.06 105.@> 106.02 105.@@5.00 5.00 5.00 5.00 5.00 5.00

    15.00 15.00 15.00 15.00 15.00 15.000.00 0.00 0.00 0.00 0.00 0.00

    116.25 115.?? 116.06 115.@> 116.02 115.@@116.25 115.?? 116.06 115.@> 116.02 115.@@115.?? 116.06 115.@> 116.02 115.@@ 116.00

    !'$e!'e 6

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    >2>.50 >25.25 >26.? >25.?1 >26.0@ >[email protected] 5.00 5.00 5.00 5.00 5.00

    0.00 0.00 0.00 0.00 0.00 0.00

    0.00 0.00 0.00 0.00 0.00 0.00>52.50 >50.25 >51.? >50.?1 >51.0@ >50.@5>52.50 >50.25 >51.? >50.?1 >51.0@ >50.@5>50.25 >51.? >50.?1 >51.0@ >50.@5 >51.02

    !'$e!'e 6

    Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% > Se'%&% ? Se'%&% @

    6>.50 65.25 66.? 65.?1 66.0@ [email protected] 5.00 5.00 5.00 5.00 5.00

    20.00 20.00 20.00 20.00 20.00 20.000.00 0.00 0.00 0.00 0.00 0.00

    652.50 650.25 651.? 650.?1 651.0@ [email protected] 650.25 651.? 650.?1 651.0@ [email protected] 651.? 650.?1 651.0@ 650.@5 651.02

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    158/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    159/293

    Se'%&% 10 Se'%&% 11 Se'%&% 12

    111.00 111.00 111.005.00 5.00 5.000.00 0.00 0.000.00 0.00 0.00

    106.00 106.00 106.00106.00 106.00 106.00106.00 106.00 0.00

    Se'%&% 10 Se'%&% 11 Se'%&% 12

    106.00 106.00 106.005.00 5.00 5.00

    0.00 0.00 0.000.00 0.00 0.00

    11.00 11.00 11.0011.00 11.00 11.0011.00 11.00 0.00

    Se'%&% 10 Se'%&% 11 Se'%&% 12

    106.00 106.00 106.005.00 5.00 5.000.00 0.00 0.000.00 0.00 0.00

    101.00 101.00 101.00101.00 101.00 101.00101.00 101.00 0.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    160/293

    Se'%&% 10 Se'%&% 11 Se'%&% 12

    106.00 106.00 106.005.00 5.00 5.00

    15.00 15.00 15.000.00 0.00 0.00

    116.00 116.00 116.00116.00 116.00 116.00116.00 116.00 0.00

    Se'%&% 10 Se'%&% 11 Se'%&% 12

    >26.02 >25.@@ >26.015.00 5.00 5.00

    0.00 0.00 0.00

    0.00 0.00 0.00>51.02 >50.@@ >51.01>51.02 >50.@@ >51.01>50.@@ >51.01 0.00

    Se'%&% 10 Se'%&% 11 Se'%&% 12

    66.02 65.@@ 66.015.00 5.00 5.00

    20.00 20.00 20.000.00 0.00 0.00

    651.02 650.@@ 651.01651.02 650.@@ 651.01650.@@ 651.01 0.00

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    161/293

    Re=erencia SL100E

    Promedio Movil

    e%&% !'$e!'e 1

    Se'%&% 1 24Se'%&% 2 24?Se'%&% 2>6Se'%&% 4 225Se'%&% 5 22?Se'%&% 6 24>Se'%&% > 2>5

    Se'%&% ? 251Se'%&% @ 251Se'%&% 10 241Se'%&% 11 26Se'%&% 12 254

    !'$e!'e 1 Se'%&% 1

    P'-&-!$,- %&!e'$-' HF!1 105.00#e%% 'e%l HA!1 24E''-' #el /'-&.@0

    !'$e!'e 2 Se'%&% 1

    P'-&-!$,- %&!e'$-' HF!1 245.00#e%% 'e%l HA!1 24?E''-' #el /'-&

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    162/293

    !'$e!'e Se'%&% 1P'-&-!$,- %&!e'$-' HF!1 2>6.50#e%% 'e%l HA!1 264E''-' #el /'-&5.25

    !'$e!'e 4 Se'%&% 1P'-&-!$,- %&!e'$-' HF!1 4.00#e%% 'e%l HA!1 11E''-' #el /'-&0

    !'$e!'e 5 Se'%&% 1P'-&-!$,- %&!e'$-' HF!1 41.50#e%% 'e%l HA!1 1>E''-' #el /'-&

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    163/293

    Semana

    1 25.002 16.50 20.>54 1?.65 [email protected]@6 [email protected]> [email protected]? [email protected]@@ [email protected] [email protected] [email protected] 1@.

    TOTALES ?6

    Pol+ticas la,orales

    SALARIO MINIMO K 172507000

    CAPACITACION DE UN OPERARIO NUEVO K 1710070000.SEMANA ORAS 40DIAS ABILES 5DIAS NORMALES DEL MES 20ORAS ETRAS SOLO DOMINGOSORAS DIARIAS ?

    6NO SE PERMITEN FALTANTES O ENTREGAS TARDIAS

    costos so,re la empresa

    COSTO DE ALMACENAMIENTO K 17500

    COSTO MATERIAL K 607250K 57?00

    Plan de producci$n

    64

    Cuanto puede producir un solo operario.

    SEMANA 40DIAS ABILES LUNES A VIERNES ?

    TIEMPO EN PRODUCIR UNA UNIDAD 0.CUANTAS UNIDADES POR DIA 26.>

    OPERARIOS FI9OS JUE SE NECESITARIAN 2.406

    APROIMACION OPERARIOS ECESO OPERARIO JUE SE NECESITA 0.60

    .60

    Pronostico#

    MINUTOS conversion a -oras

    DESPEDIR

    MATERIALES

    LA DEMANDA DE LOS 4 MESES

    PUEDEN DESPEDIR

    FI9OS

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    164/293

    Mes emanda Esperada

    1 252 1> 214 1@5 206 1@> 1@? 1@@ 1@10 1@11 1@12 1@

    T/TALES 686>

    COSTO DE ALMACENAMIENTO

    1 K 20672502 K 6257125 K 1704>71??4 K 1746>76565 K 17???7@226 K 270@7>?@> K 27>07?55? K 71517?22@ K 75>27?@10 K 7@@7?111 K 474147?5

    12 K 47?57?TOTALES K 072447@44COSTO MATERIAL1 K 6715070002 K 671507000 K 6715070004 K 6715070005 K 6715070006 K 671507000> K 671507000? K 671507000

    @ K 67150700010 K 67150700011 K 67150700012 K 671507000

    TOTALES K 47?007000COSTO DE SUB CONTRATACION1 K 02 K 0 K 0

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    165/293

    4 K 05 K 06 K 0> K 0? K 0@ K 010 K 011 K 012 K 0

    TOTALES K 0

    COSTO OPERACIONAL

    CANTIDAD DE OPERARIOS ORAS DIARIAS ?DIAS NORMALES 20

    CUANTOS DIAS TOTALES 60

    SALARIO MINIMO OPERARIO K 172507000COSTO DE CADA ORA POR OPERARIO K >7?1TOTAL COSTO K 1172507000.00

    SUMA DE TODOS LOS COSTES K 4>572@[email protected]

    CUANT/ C/STAR)A S) SE SUC/NTRATARA T// .

    Mes emanda Esperada

    1 252 1> 214 1@5 206 1@> 1@? 1@@ 1@10 1@

    11 1@12 1@T/TALES 686>

    OPERARIOS JUE SENECESITAN

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    166/293

    !'$e!'e 2 !'$e!'e !'$e!'e 4 !'$e!'e 5

    24? 264 11 1> 2522@ 265 2>1 20 224 261 20 12 2?254 256 05 41 2>2>2 254 2 50 2424@ 04 2 64 2>24? 2?1 2@ 10 2?

    02 41 24 2?@ 2>24 02 11 56 2>24@ 0 24 1 2>2@2 24 2? 42 2>261 44 55 0? 2>

    Se'%&% 2 Se'%&% Se'%&% 4 Se'%&% 5 Se'%&% 6

    101.00 241.00 262.00 250.50 226.5024? 2>6 225 22? 24>14> 5 > 22.5 20.50.1 0.1 0.1 0.1 0.1

    14.> .5 .> 2.25 2.05

    115.>0 244.50 25?.0 24?.25 22?.55

    Se'%&% 2 Se'%&% Se'%&% 4 Se'%&% 5 Se'%&% 6

    251.00 2?.50 26.00 24?.50 26.0022@ 24 254 2>2 24@22 4.5 1? 2.5 140.1 0.1 0.1 0.1 0.1

    2.2 0.45 1.? 2.5 1.4

    24?.?0 2?.@5 2>.?0 250.?5 261.60

    De%&%#%Y! &5

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    167/293

    Se'%&% 2 Se'%&% Se'%&% 4 Se'%&% 5 Se'%&% 6262.50 264.50 26.00 25?.50 255.00

    265 261 256 254 042.5 .5 > 4.5 [email protected] 0.1 0.1 0.1 0.1

    0.25 0.5 0.> 0.45 4.@

    262.>5 264.15 262.0 25?.05 25@.@0

    Se'%&% 2 Se'%&% Se'%&% 4 Se'%&% 5 Se'%&% 62>.50 [email protected] [email protected] 12.50 1?.50

    2>1 20 05 2 256.5 2@ @.5 [email protected] 4.5

    0.1 0.1 0.1 0.1 0.15.65 2.@ 0.@5 1.@5 0.45

    21.?5 2@.@0 [email protected] 14.45 1?.@5

    Se'%&% 2 Se'%&% Se'%&% 4 Se'%&% 5 Se'%&% 66.00 1?.50 16.00 26.50 45.50

    20 12 41 50 6416 6.5 25 2.5 1?.50.1 0.1 0.1 0.1 0.1

    1.6 0.65 2.5 2.5 1.?5

    4.40 1>.?5 1?.50 2?.?5 4>.5

    Se'%&% 2 Se'%&% Se'%&% 4 Se'%&% 5 Se'%&% 616.50 20.>5 1?.6 [email protected]@ [email protected] 20.>5 1?.6 [email protected]@ [email protected]

    0 0 0 0 00.1 0.1 0.1 0.1 0.1

    0 0 0 0 0

    16.50 20.>5 1?.6 [email protected]@ [email protected]

    PLANT)LLA !)2A

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    168/293

    ias La,orales

    555555555555

    60

    8-'%#$%

    /-' 8-'%"&$#%#e

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    169/293

    ias La,orales PR/UCC)/N ST/C3 )N)C)AL T/C3 !)NA T/C3 ME)

    5 600 0 2>5 1?5 600 2>5 55@ 41>5 600 55@ ?? 6@?5 600 ?? 111@ @>?5 600 111@ 1@@ 125@5 600 1@@ 16?0 15405 600 16?0 1@61 1?215 600 1@61 2242 21015 600 2242 2522 2?25 600 2522 2?0 2665 600 2?0 0?4 2@45 600 0?4 64 224

    >0 400 01>6

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    170/293

    6?

    2060

    K 172507000K >7?1K 2275007000

    K 4?675447@44

    T/TAL C/ST/

    K 17??57000 K 1@75?17250 K 2174667250K 17?57>00 K 1@706@7125 K 207@047?25K 17?60750 K 1@72571?? K 2171?575?K 17?4?7025 K 1@71@>7156 K 21704571?1K 17?5471?? K 1@726171>2 K 21711575@K 17?517106 K 1@722@7164 K 2170?072>0K 17?52764> K 1@7245716? K 2170@>7?15K 17?517?>> K 1@72>7166 K 2170?@704K 17?527262 K 1@7241716> K 2170@742@K 17?52706@ K 1@72@716> K 2170@1726

    K 17?527165 K 1@7240716> K 2170@272K 17?52711> K 1@72@766> K 2170@17>?4K 22724>7506 K 2171057556 K 25757061

    OPERARIOS CON LOS JUESE DEBE TRABA9AR

    C/ST/ E LASUC/NTRATAC)/N

    C/ST/ EMATER)ALES

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    171/293

    Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10 Se'%&% 11 Se'%&% 12

    2>.50 261.00 26.00 251.00 246.00 2?.502>5 251 251 241 26 254

    >.5 10 12 10 10 15.50.1 0.1 0.1 0.1 0.1 0.1

    .>5 1 1.2 1 1 1.55

    241.25 260.00 261.?0 250.00 245.00 240.05

    Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10 Se'%&% 11 Se'%&% 12

    260.50 24?.50 2>5.00 26?.00 241.50 2>0.5024? 02 24 24@ 2@2 261

    12.5 5.5 41 1@ 50.5 @.50.1 0.1 0.1 0.1 0.1 0.1

    1.25 5.5 4.1 1.@ 5.05 0.@5

    [email protected] 25.?5 2>0.@0 266.10 246.55 [email protected]

    PRONOSTICO

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    172/293

    Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10 Se'%&% 11 Se'%&% 122>@.00 [email protected] 11.00 21.50 02.50 1.50

    2?1 41 02 0 24 442 4?.5 @ 1?.5 21.5 0.5

    0.1 0.1 0.1 0.1 0.1 0.10.2 4.?5 0.@ 1.?5 2.15 .05

    2>@.20 2@>.5 10.10 [email protected] 04.65 16.55

    Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10 Se'%&% 11 Se'%&% 122>.50 0?.00 0?.50 1>.50 1>.50 26.00

    2@ 24 11 24 2? 554.5 16 2.5 6.5 10.5 2@

    0.1 0.1 0.1 0.1 0.1 0.1.45 1.6 0.25 0.65 1.05 2.@

    24.05 [email protected] 0?.>5 1?.15 1?.55 2?.@0

    Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10 Se'%&% 11 Se'%&% 125>.00 >.00 2@@.50 22.50 4.50 6.50

    10 2?@ 56 1 42 0?4> 4? 56.5 ?.5 1.5 2?.50.1 0.1 0.1 0.1 0.1 0.1

    4.> 4.? 5.65 0.?5 0.15 2.?5

    52.0 2.20 05.15 2.5 4.5 .65

    Se'%&% > Se'%&% ? Se'%&% @ Se'%&% 10 Se'%&% 11 Se'%&% [email protected] [email protected]@ [email protected] [email protected] [email protected] [email protected]@.42 [email protected]@ [email protected] [email protected] [email protected] 1@.

    0 0 0 0 0 00.1 0.1 0.1 0.1 0.1 0.1

    0 0 0 0 0 0

    [email protected] [email protected]@ [email protected] [email protected] [email protected] 1@.

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    173/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    174/293

    ,contratacion

    0000000000000

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    175/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    176/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    177/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    178/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    179/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    180/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    181/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    182/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    183/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    184/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    185/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    186/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    187/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    188/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    189/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    190/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    191/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    192/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    193/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    194/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    195/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    196/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    197/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    198/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    199/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    200/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    201/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    202/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    203/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    204/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    205/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    206/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    207/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    208/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    209/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    210/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    211/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    212/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    213/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    214/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    215/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    216/293

    Se'%&% 12 Se'%&% 1REF REFREF REFREF REF

    0.1 0.1REF REF

    REF REF

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    217/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    218/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    219/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    220/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    221/293

    Se'%&% 2 Se'%&% Se'%&% 4 Se'%&% 5 Se'%&% 6 Se'%&% >REF REF REF REF REF REFREF REF REF REF REF REFREF REF REF REF REF REF

    0.1 0.1 0.1 0.1 0.1 0.1REF REF REF REF REF REF

    REF REF REF REF REF REF

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    222/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    223/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    224/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    225/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    226/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    227/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    228/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    229/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    230/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    231/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    232/293

    NIVEL 0Re=erencia

    UNITEC

    NIVEL 1Re=erencia

    CAR 0 SCB

    NIVEL 2

    MATER)

    Re=erencia

    ERT0?ENT02VGA16

    UIN02LDL0?ENT04VGA02LDL06UMN2?ART04ACC0ROT02GMA16

    RNG16

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    233/293

    NIVEL 0

    UN)TEC 6

    SEMANA

    Ne,e$#%#e B'"!%

    S!-, #e Se)"'$#%#Re,e/,$-&e Pe$e&!e

    Ne,e$#%#e Ne!%Re,e/,$-&e P'e$!%

    L%&(%$e&!- #e Pe#$#-

    NIVEL 1

    CAR 06" SCA

    SEMANA

    Ne,e$#%#e B'"!%

    S!-, #e Se)"'$#%#Re,e/,$-&e Pe$e&!e

    Ne,e$#%#e Ne!%Re,e/,$-&e P'e$!%

    L%&(%$e&!- #e Pe#$#-

    CAR 06" SC

    SEMANA

    Ne,e$#%#e B'"!%

    S!-, #e Se)"'$#%#Re,e/,$-&e Pe$e&!e

    Ne,e$#%#e Ne!%Re,e/,$-&e P'e$!%

    L%&(%$e&!- #e Pe#$#-

    CAR /6 11

    SEMANA

    Ne,e$#%#e B'"!%

    S!-, #e Se)"'$#%#Re,e/,$-&e Pe$e&!e

    Ne,e$#%#e Ne!%Re,e/,$-&e P'e$!%

    L%&(%$e&!- #e Pe#$#-

    NIVEL 2 ERT"08

    D$/-&$$l$#%# e& el %l%,e& %l +&%l#el /e'$-#-

    D$/-&$$l$#%# e& el %l%,e& %l +&%l#el /e'$-#-

    D$/-&$$l$#%# e& el %l%,e& %l +&%l#el /e'$-#-

    D$/-&$$l$#%# e& el %l%,e& %l +&%l#el /e'$-#-

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    234/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    235/293

    ENT"0;

    SEMANA

    Ne,e$#%#e B'"!%

    S!-, #e Se)"'$#%#Re,e/,$-&e Pe$e&!e

    Ne,e$#%#e Ne!%Re,e/,$-&e P'e$!%

    L%&(%$e&!- #e Pe#$#-

    *?A"0

    SEMANA

    Ne,e$#%#e B'"!%

    S!-, #e Se)"'$#%#Re,e/,$-&e Pe$e&!e

    Ne,e$#%#e Ne!%

    Re,e/,$-&e P'e$!%L%&(%$e&!- #e Pe#$#-

    LL"0>

    SEMANA

    Ne,e$#%#e B'"!%

    S!-, #e Se)"'$#%#Re,e/,$-&e Pe$e&!e

    Ne,e$#%#e Ne!%Re,e/,$-&e P'e$!%

    L%&(%$e&!- #e Pe#$#-UMN"8

    SEMANA

    Ne,e$#%#e B'"!%

    S!-, #e Se)"'$#%#Re,e/,$-&e Pe$e&!e

    Ne,e$#%#e Ne!%Re,e/,$-&e P'e$!%

    L%&(%$e&!- #e Pe#$#-

    ART"0;SEMANA

    Ne,e$#%#e B'"!%

    S!-, #e Se)"'$#%#Re,e/,$-&e Pe$e&!e

    Ne,e$#%#e Ne!%Re,e/,$-&e P'e$!%

    D$/-&$$l$#%# e& el %l%,e& %l +&%l#el /e'$-#-

    D$/-&$$l$#%# e& el %l%,e& %l +&%l#el /e'$-#-

    D$/-&$$l$#%# e& el %l%,e& %l +&%l#el /e'$-#-

    D$/-&$$l$#%# e& el %l%,e& %l +&%l#el /e'$-#-

    D$/-&$$l$#%# e& el %l%,e& %l +&%l#el /e'$-#-

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    236/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    237/293

    Re,e/,$-&e P'e$!%L%&(%$e&!- #e Pe#$#-

    PA@"10

    SEMANA

    Ne,e$#%#e B'"!%

    S!-, #e Se)"'$#%#Re,e/,$-&e Pe$e&!e

    Ne,e$#%#e Ne!%Re,e/,$-&e P'e$!%

    L%&(%$e&!- #e Pe#$#-

    U)N"0;

    SEMANA

    Ne,e$#%#e B'"!%

    S!-, #e Se)"'$#%#

    Re,e/,$-&e Pe$e&!eNe,e$#%#e Ne!%

    Re,e/,$-&e P'e$!%L%&(%$e&!- #e Pe#$#-

    ERT"05

    SEMANA

    Ne,e$#%#e B'"!%

    S!-, #e Se)"'$#%#Re,e/,$-&e Pe$e&!e

    Ne,e$#%#e Ne!%Re,e/,$-&e P'e$!%

    L%&(%$e&!- #e Pe#$#-

    ACC"09

    SEMANA

    Ne,e$#%#e B'"!%

    S!-, #e Se)"'$#%#Re,e/,$-&e Pe$e&!e

    Ne,e$#%#e Ne!%

    Re,e/,$-&e P'e$!%L%&(%$e&!- #e Pe#$#-

    SLP"10

    SEMANA

    Ne,e$#%#e B'"!%

    S!-, #e Se)"'$#%#Re,e/,$-&e Pe$e&!e

    D$/-&$$l$#%# e& el %l%,e& %l +&%l#el /e'$-#-

    D$/-&$$l$#%# e& el %l%,e& %l +&%l#el /e'$-#-

    D$/-&$$l$#%# e& el %l%,e& %l +&%l#el /e'$-#-

    D$/-&$$l$#%# e& el %l%,e& %l +&%l#el /e'$-#-

    D$/-&$$l$#%# e& el %l%,e& %l +&%l#el /e'$-#-

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    238/293

    Ne,e$#%#e Ne!%Re,e/,$-&e P'e$!%

    L%&(%$e&!- #e Pe#$#-

    ERT"0>

    SEMANA

    Ne,e$#%#e B'"!%

    S!-, #e Se)"'$#%#Re,e/,$-&e Pe$e&!e

    Ne,e$#%#e Ne!%Re,e/,$-&e P'e$!%

    L%&(%$e&!- #e Pe#$#-

    ACC"05

    SEMANA

    Ne,e$#%#e B'"!%

    S!-, #e Se)"'$#%#Re,e/,$-&e Pe$e&!e

    Ne,e$#%#e Ne!%Re,e/,$-&e P'e$!%

    L%&(%$e&!- #e Pe#$#-

    PR2"1;

    SEMANA

    Ne,e$#%#e B'"!%

    S!-, #e Se)"'$#%#

    Re,e/,$-&e Pe$e&!eNe,e$#%#e Ne!%

    Re,e/,$-&e P'e$!%L%&(%$e&!- #e Pe#$#-

    P)N"0>

    SEMANA

    Ne,e$#%#e B'"!%

    S!-, #e Se)"'$#%#Re,e/,$-&e Pe$e&!e

    Ne,e$#%#e Ne!%Re,e/,$-&e P'e$!%

    L%&(%$e&!- #e Pe#$#-

    UMM"1

    SEMANA

    Ne,e$#%#e B'"!%

    S!-, #e Se)"'$#%#

    D$/-&$$l$#%# e& el %l%,e& %l +&%l#el /e'$-#-

    D$/-&$$l$#%# e& el %l%,e& %l +&%l#el /e'$-#-

    D$/-&$$l$#%# e& el %l%,e& %l +&%l#el /e'$-#-

    D$/-&$$l$#%# e& el %l%,e& %l +&%l#el /e'$-#-

    D$/-&$$l$#%# e& el %l%,e& %l +&%l#el /e'$-#-

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    239/293

    Re,e/,$-&e Pe$e&!eNe,e$#%#e Ne!%

    Re,e/,$-&e P'e$!%L%&(%$e&!- #e Pe#$#-

    Recepciones Previstas

    UN)TEC 6

    CAR 06" SCA

    CAR 06" SC

    CAR /6 11

    ERT"08

    ENT"0

    *?A"1>

    U)N"0LL"08

    ENT"0;

    *?A"0

    LL"0>

    UMN"8

    ART"0;

    ACC"06

    R/T"0

    ?MA"1>

    RN?"1>LAR"04

    PA@"10

    U)N"0;

    ERT"05

    ACC"09

    SLP"10

    ERT"0>

    ACC"05

    PR2"1;

    P)N"0>

    UMM"1

    ?AST/S SEMANALES

    Recepciones Previstas

    !-!%le

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    240/293

    DIAGRAMA DE ARBOL UNITEC

    UNITEC

    AR 06 SCA UN)TEC CAR

    unidades Re=erencia

    15 LAR0>

    1 16 PAZ102 1> UIN044 UIN026 ENT022 1? ERT054 ACC04 ROT024 1@ ACC0@2 20 SLP102 21 ERT06

    2 ART044 22 ACC054 2 PR914

    24 PIN06

    25 UMM12

    ABRIL 4 5

    2@1 246 25@

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    241/293

    Lead Time Recepciones pendientes

    1 5

    CAR 06" SC

    Lead Time Recepciones pendientes

    2 0

    ALES E LA RE!ERENC)A CAR 06" SCA

    Lead Time Recepciones pendientes

    1 0 1 0 10 140 H !'$ e IV

    1 0 1 5 10 H1 !'$ e III1 0 1 0 1 0 1 0 2 10 1 0 2 5 40 H !'$ e II2 10

    4 20

    Stoc deSe(uridad

    Stoc deSe(uridad

    Stoc deSe(uridad

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    242/293

    "> "5 ";

    "> "5 ";

    "> "5 ";

    "> "5 ";

    545 5?0

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    243/293

    "> "5 ";

    "> "5 ";

    "> "5 ";

    4>0 5?0

    "> "5 ";

    "> "5 ";

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    244/293

    "> "5 ";

    "> "5 ";

    "> "5 ";

    "> "5 ";

    "> "5 ";

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    245/293

    1120

    "> "5 ";

    "> "5 ";

    ?25

    "> "5 ";

    "> "5 ";

    1120 1145 1164

    "> "5 ";

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    246/293

    560

    "> "5 ";

    560

    "> "5 ";

    2>0

    "> "5 ";

    50

    "> "5 ";

    2?0

    "> "5 ";

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    247/293

    545 5?0

    "> "5 ";

    140

    "> "5 ";

    550

    "> "5 ";

    560 5?0 5>>

    "> "5 ";

    2@0 2@0 06

    "> "5 ";

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    248/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    249/293

    CAR 0

    AR 0

    06 SC UN)TEC CAR 11

    unidades Re=erencia unidades

    2 ESF 10 2

    214121121

    222

    12

    MAYO6 > ? @

    242 260 2?0 1

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    250/293

    Costos miles B#

    1 6@

    Costos miles B#

    0 2?2

    Costos miles B# unidades

    10 50 0 2 1100 2> 2

    140 0 440 0 620 4 2100 16 40 50 440 410 2? 210 5 220 24 220 2 4

    20 > 4

    isponilidad en elalmacn

    isponilidad en elalmacn

    isponilidad en elalmacn

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    251/293

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    252/293

    "6 " "1 1?40

    10 000

    ?0

    ?0?0 ?>0 ?6? ?>0

    "6 " "1 1560

    0 000

    560560

    560 5?0 5>> 5?0

    "6 " "1 1560

    100 10100

    4>04>0

    5?> 4@> 52 5?0

    "6 " "1 12240

    140 000

    21002100

    2100 220 22 220

    "6 " "1 116?0

    40 550

    16451645

    1645 1>40 1616 1>40

  • 7/26/2019 TRABAJO COLABORATIVO _ FINAL v2.xlsx

    253/293

    "6 " "1 1560

    20 000

    540540

    540 5?0 5>> 5?0

    "6 " "1 1140

    100 000

    >0

    >0>0 0 0 0

    "6 " "1 11120

    0 000

    10@010@0

    10@0 1160 115@ 1160

    "6 " "1 11120

    40 000

    10?010?0

    10?0 1160 115@ 1160

    "6 " "1 11120

    10 10100

    11201120

  • 7/26/2019 TRABAJO COLABORATIVO _ F