trabajo colaborativo _ final v2.xlsx
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
@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