INSTITUCIÓN UNIVERSITARIA UNIVERSITARIA POLITÉCNICO GRANCOLOMBIANO FACULTAD DE CIENCIAS ADMINISTRATIVAS, ECONÓMICAS Y CONTABLES DEPARTAMENTO ACADÉMICO DE ADMINISTRACIÓN
RESPONSABILIDAD SOCIAL Y EMPRESARIAL SEGUNDA ENTREGA ENTREG A - PROYECTO GRUPAL. ECOPETROL S.A
INTEGRANTES ANA SILV SILVIA IA PARADA PARADA PUENTES DAVID ANDRES RIANO VIDALES DIANA SOFIA LLANOS OTALORA #OSE LISANDRO SOSSA GUTIERRE$ %ELYN VIVIANA ACU&A RAMIRE$ SANDRA 'UITIAN MATEUS
COD.0911020098 COD.0911020098 COD.112111026 COD.112111026 COD.1121!01"0 COD.1021 02111026 26 COD.1211!000 COD.1011020(!6 COD.10 11020(!6
TUTOR ERNESTO FABIAN SAMPAYO OLIVEROS
BOGOT) DC 2016
CONTENIDO
1.
INTRODUCCIÓN.........................................................................................................
2.
#USTIFICACION..........................................................................................................(
!.
OB#ETIVOS.................................................................................................................(
!.1 OB#ETIVO GENERAL...................................................................................................( !.2 OB#ETIVOS ESPEC*FICOS.........................................................................................6 . INVESTIGACION DEL PROBLEMA ...............................................................................8 (.
UTILI$ACION DE TECNICAS +EURISTICAS...........................................................10
(.1 C/ O/ 3 P3/4 5EO'.............................................................................10 (.2 S/73 M37..................................................................................................................12 (. B7:34 3 P3;44 < P3.......................................................................................1( (.! C4=4 U//4 M;/4.................................................................................................1( 6.
METODOLOGIA >AGNER ? >+ITIN.......................................................................1(
".
CONCLUSIONES Y RECOMENDACIONES..............................................................1(
8.
BIBLIOGRAF*A..........................................................................................................16
2
1. INTRODUCCIÓN T3/34 :44 3@33:/ 37 :43/4 < 74= :4:34= /=4= 3 37 74 G33:/ 3 P4::/ =43 :/:= 3 /3=/4/34 3 743=, 3334= /3=/ < 3=477 7 3 34 3 7 47;/: 3 /=/:/ 37 34 4:4 M73>:, 3 7 C4H; M73 3 37 3:4 7/43/:4. S3 3=3 7 3 3 3=3 4:4 4 74 3 7= 7//:/43= 3 4::/ 7= 33/ 7= :/3= 3 /3= 3/= 3 37 J/4 =33=3. E7 4:4 M73>:, 3= 3744 3 C/ < 33 =3 3/4 4433 PK =3 /=//4 =3733 74= 3:4= 74:73=. S3 33 / 3 7 /=/:/ 37 4:4 4 =3 3 3=4 3 / 3 < 3 = 3 =3 ///:3 74= :4=4= 4 37 7:3/34 3 /3=.
2. JUSTIFICACIÓN DEL PROBLEMA T4 33= 3 =3 3/3 7 :43:/7/:/ < 7 /=/:/ 3 4:4= 33 3=73:3 4374 3@/: 3 =/=@ 7= 3:3=/3= 3 7 :4H;, 3=43 3 3 44 7 3 3 == 4:4=, 3 333 74 34 < 33 == :/=. 7 C4H; M73 3=K 3=34 =43:4=4= 3 74= 4:3=4= 3 74;=/: 74 3 @3: 74= 4:3=4= :43:/73=, 4 7 37 :=4 7 7/:34= :/:= 3 /3=/4/34 3 743= 3/3 37 3=4774 3 /@333= 34474;= :44 7= 3;=/:= :/ / 3 3/4, S/73 M37, :4=4 //4 ;/4, 7:34 3 3/44 < 3 < 7 34474; >3 ? >//.
3. OBJETIVOS 3.1 OBJETIVOS GENERAL C433 < 3=477 /@333= 34474;= 3/3 7= :/:= 3 /3=/4/34 3 743=, 374 43= 3 34 7 47;/: 3 /=/:/ 37 4:4 M73>: 3 7 C4H; M73.
3.2 OBJETIVOS ESPECÍFICOS !
•
•
•
I3=/, :433 < 7/: 74= 44= 3 3;=/: :/ / 3 3/4, S/73 M37, :4=4 //4 ;/4 < 7:34 3 3/44 < I3=/, :433 < 7/: 7 34474; >3 ? >//. C4 < 7/ 7= 34474;= < 7= 3;=/:= 7/:= 3// = 3:43:/43= < :4:7=/43= :4 =3 3 74= 3=74= 43/4=. E74 /@43 3/34 3 :3 74= /:/73= 3=74= 43/4= 3, 3 :3 37 7 3 3/4=, 74= :4=4= 3 3/4, /3/4 < 74= :4=4= 473= 3 7 47;/: 3 3/4=.
4. INVETIGACIÓN DEL PROBLEMA E7 :4=4 37 4:4 /33 =3= /:/43= /@3== =; •
•
•
S3= 2", 28, !8, 3 :4=4 3 3/4 3= 3 2000, 7 3 3 4:4 3= 3 1200 /3= 3 < 4= /73= 3 :4=4 3 37 /3/4 51 1 2. S3= 29 :4=4 /=/4 3 == 3= /73=, 3K= 3 /@33:/=3 7= 3K= =3=. S3= !0, 1, :4=4 /73= 3 == 3= /73=, 3K= 3 /@33:/=3 7= 3K= =3=.
•
S3= !1 44= 74= :4=4= ; :4 3=3:4 7= 3K= =3=.
•
S3= !2 44= 74= :4=4= ; :4 3=3:4 7= 3K= =3=.
•
S3= !! 44= 74= :4=4= ; :4 3=3:4 7= 3K= =3=.
•
S3= !, , 44= 74= :4=4= ; :4 3=3:4 7= 3K= =3=.
•
•
S3= !(, !6, !", !9, 0, 2, !, 44= 74= :4=4= ; :4 3=3:4 7= 3K= =3=. S3= 7 (2, 44= 74= :4=4= ; :4 3=3:4 7= 3K= =3=.
E :4:7=/, 3 37 =34 =33=3 37 H4 74= :4=4= 3 /3/4, 3 3/4 < 7 3 3 4:4, =/34 == 43/4=, =; 1. C4=4 3 /3/4 5(8 =33=3 1.(2 4 =3.
2. C4=4 3 3/4 5("00 =33=3 2188 4 =3. !. L 3 5!1200 /3= =33=3 128 4 =3. P 3=3 33:/:/4 4= 73 74= :4=4= 3 3/4 < 3 /3/4 3 3/44 3 26 =3= 3/34 :44 =3 7 3 33 =3 4 =3 :44 :3 3@33:/ 7 =//33 7 SEMANA
DEMANDA
COSTO DE PEDIDO
COSTO DE INVENTARIO
2"
1200
2000
1
28
1200
2000
1
29
800
2200
1
!0
1000
2200
2
!1
1000
1900
2
!2
!00
2000
1
!!
2200
2000
1
!
100
2000
2
!(
1800
2200
1
!6
600
2200
2
!"
1200
1900
1
!8
1200
2000
2
!9
800
2000
2
0
1000
2000
2
1
1000
2200
2
2
!00
2200
1
!
2200
1900
2
100
2000
1
(
1800
2000
2
6
600
2000
1 (
"
1200
2200
1
8
1200
2200
2
9
800
1900
1
(0
1000
2(00
2
(1
2200
2(00
1
(2
1800
2(00
1
5 TECNICAS HEURISTICAS U 44 3;=/:4 3=7 =3 3@43 3 43: 7 3=: 37 473 3/3 37 =4 3 :44 3 37= :/473=, 43/34 =47:/ 3, 3= 3:/, :3: 7 / 4 3 4:=/43= 7 /. L= :/:= 3;=/:= =3 = :4 4 3= 4=/73 433 37 /4. A :4/:/ 3=34= :4 3 377=
5.1 Can!"a" Ó#!$a "% P%"!"& 'EO() L :/ 4/ 3 3/4 =: 3:4 37 44 3 3/4 3 3: 7 ;/4 37 :4=4 47 37 /3/4 3 7 33=. E= 3;=/: =3 = 3 3= =3=4= @373=. -
E7 /34 3= 3 7 33= :44:3 :K7 3= 7 /7/:/ 7 3 74= ;:74= 3 =3 3:3 3 37 /3/4 E7 =34 3= 3 7 @3:3:/ :4 7 :7 7 33= /7/ 37 /3/4 4 ; :4 37 /34 Y 7 Q7/ 3 74= 3/4= 3 =3 :474: 337 7= 3J/=3:/= 3 /3/4 =3 3:/3 3 37 434 3J:4 3 3 74= /3/4= =3 4.
L4= :4=4= K=/:4= 33 3 :3 =4
C4=4= 3 3/4 C4=4= 3 3//34 37 /3/4 C4=4= 473=
PERIODO
1
DEMANDA
1200
O PLANEADA S
2400
ENTREGAS
1200
INVENTARIOS
1200 6
2
1200
-
1200
-
3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26
800 1000 1000 300 2200 1400 1800 600 1200 1200 800 1000 1000 300 2200 1400 1800 600 1200 1200 800 1000 2200 1800
1800 1300 2200 1400 1800 1800 2000 2300 2200 1400 1800 1800 2000 1000 2200 1800
800 1000 1000 300 2200 1400 1800 600 1200 1200 800 1000 1000 300 2200 1400 1800 600 1200 1200 800 1000 2200 1800
1000 300 1200 800 1300 300 1200 800 -
31200
8100
31200
31200
Promedio Co!o Orde"#r &em#"d# 26 em#"# &em#"d# %2 em#"# 'A(o) Promedio Co!o A*m#+e"#r ,or "id#d ,or em#"# Promedio Co!o A*m#+e"#r ,or "id#d ,or #(o
2103$8% 31200$0 0 62400$0 0 1$46 .6$00
P 3@3:4 37 473 734 =3 3=3 3 7 =//33 3 / A &
18%8$6224 2103$8% 62400$00 "
.6$00
D43 ' :/ 3 =3 33 3/ A :4=4 3 7 43 3 :4 4 3:/ 4::/ D 3 7 + :4=4 7 3 3//34 3 /3/4 POLITICA DE PEDIDO
#Ordene ! C"" Orden$r .0630$31
In%en$r&" Pr"'ed&"
C"" T"$( A)" .0630$31 141260$61 * Co!o To!#* 26 70+630,31 em#"#
5.2 S!*+%, M%a* E7 74/4 S/73 M37 3 44 +7 M37 < E S/73 3= 44 3;=/:4 3 / 3 333 433 37 :4=4 43/4 ;/4 7 43 3 :4 K= 37 :4=4 3 33 37 /3/4 4 3/44 3 @:/ 37 Q34 3 3/44= @4= 3 37 3/4 :7 33. E7 :K7:74 =3 33K :4 3= @:/ =3 /:333. S 43/4 3= 37 3 /// 7 = 3 74= :4=4= 3 3:/ 3 /3/4. • • • •
3= :4=3 A 3= :4=3 D3 /73 T/34 /73
V/73= 3/44= 5=3 D3 4 3/44 A :4=4 3 7 43 3 :4 %:4=4 /73 :4=4 3 7:3 / 3 /3/4
F47 8
- '$)1/$'A0HD 202HD300'$1)HD$ P3/441 % 52" A P3/442 % 5 5AD PERIO& O
SEMAN AS
DEMAN DA
1 2 3 1 2 3 1 2 1 2 1 2 1 2 1 2 1 1 2 3 1 2
2. 28 2 30 31 32 33 34 3% 36 3. 38 3 40 41 42 43 44 4% 46 4. 48
1200 1200 800 1000 1000 300 2200 1400 1800 600 1200 1200 800 1000 1000 300 2200 1400 1800 600 1200 1200
3 1 1 2
4 %0 %1 %2
800 1000 2200 1800
DEMAN S-MA COSTO COSTO DA DE DE INVENTA AC-MINVEN PEDID RIO L+ T+ O 1200 1 0 2000 2400 1 1 2000 3200 1 2 2200 1000 2 0 2200 2000 2 2 100 2300 1 4 2000 2200 1 0 2000 3600 2 1 2000 1800 1 0 2200 2400 2 1 2200 1200 1 0 100 2400 2 1 2000 800 2 0 2000 1800 2 2 2000 1000 2 0 2200 1300 1 2 2200 2200 2 0 100 1400 1 0 2000 3200 2 1 2000 3800 1 3 2000 1200 1 0 2200 2400 2 1 2200 800 1800 2200 4000
1 2 1 1
0 1 0 1
100 2%00 2%00 2%00
d./
'
2000 3200 4800 2200 4200 %400 2000 3400 2200 2800 100 3100 2000 4000 2200 2800 100 2000 3800 %600 2200 3400
2000 1600 1600 2200 2100 1800 2000 1.00 2200 1400 100 1%%0 2000 2000 2200 1400 100 2000 100 1866$. 2200 1.00 633$3333 33 200 2%00 21%0
100 200 2%00 4300
4200$0 TOTAL
PERIODO
DEMANDA
PLANEADAS
ENTREGAS
INVENTARIOS
1
12
32
12
2 9
2
12
3
4
1
23
1
13
5
1
1
3
3
3
6
22
3
22
14
7
1
24
1
1
11
12
24
12
12
12
13
1
14
1
1
15
1
13
1
1
3
16
22
22
22
1
14
3
14
24
17
1
1
2
21
12
22
12
23
24
1
25
22
2
1 312
12
14
14
12
12 1
3
3
24
12
12
12 1
1
1 4
22
1
1 157
10
5.3 C&8& Un!a,!& M9n!$& A* i#* 5e e" *o do m!odo #"!eriore$ E* *i7ro P*#"e#+i" 9 Co"!ro* de *# Prod++i" e+ri!o ,or "ie* Si,,er #! #* :6;$ de+ri7e e!#
orm# 5e e* +o!o m="imo "i!#rio re,o"de # " +?*+*o @ei7*e +9o ,"!o e e"+e"!r# e" *# +#"!id#de >=i+# de *o e*eme"!o 5e e +om7i"#"$ ,ero !#m7i" de *o ,re+io de +#d# "o de e**o
PERIOD SEMAN O A 1 2 1 2 3 1 2 3 4 1 2 3 1 2 3 1 2 3 4 1 2 3 1 1 2 3
DEMAN COST DA O AC-M- INVEN L TARIO 1200 1 2400 1 800 1 1800 2 2800 2 300 1 2%00 1 300 2 %.00 1 600 2 1800 1 3000 2 800 2 1800 2 2800 2 300 1 2%00 2 300 1 %.00 2 600 1 1800 1 3000 2 800 1 1000 2 3200 1 %000 1
DEMAN DA
2. 28 2 30 31 32 33 34 3% 36 3. 38 3 40 41 42 43 44 4% 46 4. 48 4 %0 %1 %2
1200 1200 800 1000 1000 300 2200 1400 1800 600 1200 1200 800 1000 1000 300 2200 1400 1800 600 1200 1200 800 1000 2200 1800
S-MA 0 1 0 1 3 0 1 2 4 0 2 3 0 2 4 0 1 3 4 0 1 2 0 0 2 3
COST O COSTO PEDID TOTAL O 2000 2000 2000 4000 2200 2200 2200 4400 100 6300 2000 2000 2000 4000 2000 6000 2200 8200 2200 2200 100 4100 2000 6100 2000 2000 2000 4000 2200 6200 2200 2200 100 4100 2000 6100 2000 8100 2000 2000 2200 4200 2200 6400 100 100 2%00 2%00 2%00 %000 2%00 .%00 COSTO C-M
C+-+M 1$6666666. 1$6666666. 2$.% 2$44444444 2$2% 6$6666666. 1$6 1$%38461%4 1$438%64 3$6666666. 2$2......8 2$03333333 2$% 2$22222222 2$21428%.1 .$33333333 1$64 1$%64102%6 1$4210%263 3$33333333 2$33333333 2$13333333 2$3.% 2$% 1$%62% 1$% %4.00
C+-+M NMERO PE&I&OS COSTO PE&I&OS
1000$00 11
COSTO INVENTARIOS COSTO &EL PLAN
3%.00$00 %4.00$00
5.4 Ba*an:%& "% #%"!"& ; #a,% E!e M!odo i"!e"!# mi"imi#r *# m# de* +o!o D#ri#7*e ,#r# !odo *o *o!e e de7e re+ord#r e" e* #"?*ii de* EO/ 5e i *# dem#"d# e "i>orme$ e* +o!o de orde"#r o ,re,#r#r e i#* #* +o!o de #*m#+e"#r A"5e e!e #rme"!o e +orre+!o ,#r# dem#"d# "i>orme$ "o e +ier!o ,#r# *# dem#"d# irre*#r$ e" *# 5e e* i"De"!#rio ,romedio "o e *# mi!#d de* !#m#(o de* *o!e Si" em7#ro$ ,ede ,ro,or+io"#r o*+io"e r#o"#7*e ,#r# *# dem#"d# irre*#r
SEMANA
2. 28 2 30 31 32 33 34 3% 36 3. 38 3 40 41 42 43 44 4% 46 4. 48 4 %0 %1 %2
COSTO COSTO COSTO NI&A&E &EL &EMAN& INVENTAR &E &EL SA INVENTAR A IO FINAL OR&ENA INVENTAR PE&IR IO R IO TOTAL NI&A& 1200 3200 2000 2000 1 2000 1200 800 1 800 800 0 1 0 1000 1000 0 2200 2 0 1000 1300 300 100 2 600 300 0 1 0 2200 2200 0 2000 1 0 1400 3200 1800 2000 2 3600 1800 0 1 0 600 600 0 2200 2 0 1200 1200 0 100 1 0 1200 2000 800 2000 2 1600 800 0 2 0 1000 2000 1000 2000 2 2000 1000 0 2 0 300 300 0 2200 1 0 2200 3600 1400 100 2 2800 1400 0 1 0 1800 3600 1800 2000 2 3600 600 1200 1 1200 1200 0 1 0 1200 2000 800 2200 2 1600 800 0 1 0 1000 3200 2200 2%00 2 4400 2200 0 1 0 1800
1800
0
2%00
1
COSTO TOTAL ACMLA &O 4000 4800 4800 .000 %00 %00 11%00 1.100 1.100 1300 21200 24800 24800 28800 28800 31000 3%.00 3%.00 41300 42%00 42%00 46300 46300 %3200 %3200
0 12
S-TOTAL
PERIOD OS 1 2 3
COSTO ALMACENAR, MANTENER 0 &2Dr2480G%4 2480H&3Dr'2)3440G%4 3440H&4Dr'3)1040%
4
4
6
* 31+500
* 24+200
* 55+700
METODOLOGIA
E=3 74/4 /33 37 /=4 43/4 3 74= 3@43= 3;=/:4=, /// 37 :4=4 /73 3 /3/4, 37 :4=4 3 43 53 < 37 3 33 /3/4 3 37 4/43 3 73:/. L /@33:/ 3= 3 37 74/4 3 >3 >// 33 =47:/ 3 :4=4 ;/4 3 :4:3 :/ / 43 '/. E7 4:3//34 3 4//:/ 3=K =4 3 4:/ /K/:W 37Q 4= 7= 3= 4=/73= 3 43 :/ 7 3 3 : 3/44 37 4/43 3 73:/. L /:7/ 3 =3 44 =3 = 3 3 4 :4=/3 4= 7= 47;/:= 4=/73=W 4/43 3 3/44=, 37 Q34 3 47;/:= 3= 2-1. S3 4=3 37 3:4 3 3 43 33 3 =/=@:3 4 7 3 :/34 Q34 3 3/44=. AD2"D28D29XD!6
6 CONCLUSIONES > RECOMENDACIONES COMPARACION METO&O
COSTO TOTAL
EO/ SILVER MEAL COSTO NITARIO MINIMO BALANCEO &E PERIO&O Y PARTE
.063031 4200 %4.00 %%.00
1!
&e7ido # *o re*!#do o7!e"ido$ e +o"+*9e 5e *#
C4 37 3=33 4 744= /3/@/: :/34= =3:4= 3 7= /@333= 34474;= 3;=/:= 3 4= 3//34 7: =47:/43= /= < 3 /33 /:/3:/ 34 3 7 3@//:/ 37 H4 3 743 3 4::/ 4 74 3 = //7/ 3=3 /:/3:/ 34 37 :4=4 43:/7 3 7= :4H;=. A=; /=4 744= :4:7/ 3 7 /:7=/ 3 7 /=3=/ 37 743 3= 37334 Q/7 3=4 3 =3 :44:3 7 /3=/ 3 7= 37:/43= 3 :3 3 37 4:3=4 3 @/::/ < =3 4=3 3 37 H4 37 /3=/4/34 37 743 33:3 3 3 :4=/373 3 37 H4 37 743 3 4::/. P4 44 74 7 ::/ 3 74= 743= /=4/73= 3 3/ / 4 : /4 3 3/ / 4 : /4 3 3/ /33 /:/3:/ 3 7 :44=/:/ 37 H4 37 743 3 4::/ 3=4 3 7 3:/=3 /=/<3 37 H4.
BIBLIOGRAFÍA
O&'&$&n de( $'$)" de( ("e+ '>) O,!imi#+i" de* !#m#(o de* *o!e de ,rod++i" O7!e"ido de M:"d" ;e) A,*i+#+i" de !re me!odo de o*+i" #* ,ro7*em# de dime"io"#mie"!o de *o!e 9 MRP O7!e"ido de
1