DATOS
US$/GL 1.20 1.65
COSTO DE PRODUCCIÓN
Planta de Cincinati Planta de Oakland
a n A a t n a S
COSTO DE ENVÍO
Planta de Cincinati Planta de Oakland Galon alones es )E* )E*UE)+ UE)+,O ,OSS -GL GL
o s a P l E
# 0.22 22% 22%1 1
n o t e l d n e P
0.% 0.'% 6 600
n o t s u o H
0.& 0.%( 02 02(0
s a s n a
0.%5 # 10 100%% 0%%' '
s e l e " n ! A s o L
0.&6 # 2%1 2%15'0 5'0
# 0.22 6% 6%'61 '61
SOLUCIÓN
a n A a t n a S
MATRIZ DE DATOS
Planta de Cincinati Planta de Oakland
1.'
a n A a t n a S
MATRIZ DE RESULTADOS
Planta de Cincinati Planta de Oakland
o s a P l E
n o t e l d n e P
n o t s u o H
s a s n a
2.0% 2.&(
2.0& 2.1%
1.65
1.56
o s a P l E
n o t e l d n e P
n o t s u o H
s e l e " n ! A s o L
1.'
s a s n a
s e l e " n ! A s o L
e l l i 4 n o s k c a 3
e l a d n e l G
# 0.22 &&6(
0.&% # 6%6
e l a d n e l G
t 6 o 7 e " d i 6 5
k c o ) e l t t i L
0.&% # 1%56
0.&% # 111%'5
# 0.15 112000
e l l i 4 n o s k c a 3
k c o ) e l t t i L
t 6 o 7 e " d i 6 5
1.5%
1.5%
1.5%
1.'
e l a d n e l G
o t n e 8 a 6 c a S
o t n e 8 a 6 c a S
1.0 e l l i 4 n o s k c a 3
k c o ) e l t t i L
t 6 o 7 e " d i 6 5
o t n e 8 a 6 c a S
Poduccio9n O:E);A,A -GL 500000 500000
Microsoft Excel 12.0 Informe de sensibilidad Hoja de cálculo: [Caso Solution lus !"SE.xlsx#Hoja1 Informe creado: 10$0%$201% 01:2&:1' a.m.
Celdas cambiantes Celda
$B$10 $C$10 $D$10 $E$10 $F$10 $G$10 $$10 $!$10 $#$10 $$10 $%$10 $'$10 $($10
*ombre
x12 x13 x14 x15 x18 x19 x20 "11 "12 "13 "1& "17 "21
(alor I+ual
129,359 0 37,111 22,418 7,049 &4,7&1 33,&89 112,000
)radiente reducido
2 2 2 2 2 1 -
)est*icci+nes Celda
$$13 $$14 $$15 $$1& $$17 $$18 $$19 $$20 $$21 $$22 $$23 $$24 $$25
*ombre
lanta de Cincinati .+tal %! lanta de aland .+tal %! anta na .+tal %! El as+ .+tal %! endlet+n .+tal %! +st+n .+tal %! ansas .+tal %! %+s neles .+tal %! Glendale .+tal %! #acs+n6ille .+tal %! %ittle )+c .+tal %! B*ide+*t .+tal %! ac*ament+ .+tal %!
(alor I+ual
Multi,licador de -a+ran+e
1&&4&9/81&27 0 23991&/88102 0 22418 1/8700000048 0 0 7048/8810204 0 0 0 129358/81&27 0 &47&1 0/2199999988 33&89 0/2199999988 1/818989E-12 0 37111 0 0 0 112000 0/15000000&
Microsoft Excel 12.0 Informe de sensibilidad Hoja de cálculo: [Caso Solution lus !"SE.xlsx#Hoja1 Informe creado: 10$0%$201% 01:'1:' a.m.
Celdas cambiantes Celda
$B$10 $C$10 $D$10 $E$10 $F$10 $G$10 $$10 $!$10 $#$10 $$10 $%$10 $'$10 $($10
*ombre
x12 x13 x14 x15 x18 x19 x20 "11 "12 "13 "1& "17 "21
(alor I+ual
100,447 241,570 &8,48& 148,58& 111,475 22,418 &,800 80,290 &4,7&1 33,&89 292,042
)radiente reducido
1 2 -
)est*icci+nes Celda
$$15 $$1& $$17 $$18 $$19 $$20 $$21 $$22 $$23 $$24 $$25 $$13 $$14
*ombre
anta na .+tal %! El as+ .+tal %! endlet+n .+tal %! +st+n .+tal %! ansas .+tal %! %+s neles .+tal %! Glendale .+tal %! #acs+n6ille .+tal %! %ittle )+c .+tal %! B*ide+*t .+tal %! ac*ament+ .+tal %! lanta de Cincinati .+tal %! lanta de aland .+tal %!
(alor I+ual
Multi,licador de -a+ran+e
22418 &800 80290 100447 241570 &47&1 33&89 &848& 14858& 111475 292042 &705&4 500000
1/7199999988 0/590000003& 0/340000003& 1/&4999997&2 1/5599999428 0/0&99999928 0/0&99999928 1/5399999&19 1/5399999&19 1/5399999&19 0 0 0/15000000&
*%%%%%
)%%%%%
(%%%%%
$%%%%%
&%%%%% '%%%%%
% Planta de Cincina Planta de Oakland Santa Ana
#'%%%%%
#&%%%%%
#$%%%%%
El Paso
Pendleton Houston
Kansas Los Ángeles Glendale JacksonvilleLile Rock Bidge!otSaca"ento
+otal L, Holgua
Microsoft Excel 12.0 Informe de sensibilidad Hoja de cálculo: [Caso Solution lus !"SE.xlsx#Hoja1 Informe creado: 10$0%$201% 01:'/: a.m.
Celdas cambiantes Celda
$B$10 $C$10 $D$10 $E$10 $F$10 $G$10 $$10 $!$10 $#$10 $$10 $%$10 $'$10 $($10
*ombre
x12 x13 x14 x15 x18 x19 x20 "11 "12 "13 "1& "17 "21
(alor I+ual
100,447 241,570 &8,48& 148,58& 111,475 22,418 &,800 80,290 &4,7&1 33,&89 112,000
)radiente reducido
1 2 -
)est*icci+nes Celda
$$15 $$1& $$17 $$18 $$19 $$20 $$21 $$22 $$23 $$24 $$25 $$14 $$13
*ombre
anta na .+tal %! El as+ .+tal %! endlet+n .+tal %! +st+n .+tal %! ansas .+tal %! %+s neles .+tal %! Glendale .+tal %! #acs+n6ille .+tal %! %ittle )+c .+tal %! B*ide+*t .+tal %! ac*ament+ .+tal %! lanta de aland .+tal %! lanta de Cincinati .+tal %!
(alor I+ual
Multi,licador de -a+ran+e
22418 &800 80290 100447 241570 &47&1 33&89 &848& 14858& 111475 112000 319958 &705&4
1/8700000048 0/7400000095 0/4900000095 1/&4999997&2 1/5599999428 0/2199999988 0/2199999988 1/5399999&19 1/5399999&19 1/5399999&19 0/15000000& 0 0
Microsoft Excel 12.0 Informe de res,uestas Hoja de cálculo: [Caso Solution lus !"SE.xlsx#Hoja1 Informe creado: 10$0%$201% 01:'&:' a.m.
Celda +beti6+ ':nim+; Celda
*ombre
$$10 C+st+s
(alor ori+inal
1,173,304
(alor final
1,173,304
Celdas cambiantes Celda
$B$10 $C$10 $D$10 $E$10 $F$10 $G$10 $$10 $!$10 $#$10 $$10 $%$10 $'$10 $($10
*ombre
x12 x13 x14 x15 x18 x19 x20 "11 "12 "13 "1& "17 "21
(alor ori+inal
100,447 241,570 &8,48& 148,58& 111,475 22,418 &,800 80,290 &4,7&1 33,&89 112,000
(alor final
100,447 241,570 &8,48& 148,58& 111,475 22,418 &,800 80,290 &4,7&1 33,&89 112,000
)est*icci+nes Celda
$$15 $$1& $$17 $$18 $$19 $$20 $$21 $$22 $$23 $$24 $$25 $$14 $$13
*ombre
anta na .+tal %! El as+ .+tal %! endlet+n .+tal %! +st+n .+tal %! ansas .+tal %! %+s neles .+tal %! Glendale .+tal %! #acs+n6ille .+tal %! %ittle )+c .+tal %! B*ide+*t .+tal %! ac*ament+ .+tal %! lanta de aland .+tal %! lanta de Cincinati .+tal %!
(alor de la celda
3rmula
22418 $$15<$=$15 &800 $$1&<$=$1& 80290 $$17<$=$17 100447 $$18<$=$18 241570 $$19<$=$19 &47&1 $$20<$=$20 33&89 $$21<$=$21 &848& $$22<$=$22 14858& $$23<$=$23 111475 $$24<$=$24 112000 $$25<$=$25 319958 $$14><$=$14 &705&4 $$13?<0
Estado
ci+nal ci+nal ci+nal ci+nal ci+nal ci+nal ci+nal ci+nal ci+nal ci+nal ci+nal ci+nal ci+nal
4i5er+encia
0 0 0 0 0 0 0 0 0 0 0 180042 &705&4
Microsoft Excel 12.0 Informe de sensibilidad Hoja de cálculo: [Caso Solution lus !"SE.xlsx#Hoja1 Informe creado: 10$0%$201% 01:'&: a.m.
Celdas cambiantes Celda
$B$10 $C$10 $D$10 $E$10 $F$10 $G$10 $$10 $!$10 $#$10 $$10 $%$10 $'$10 $($10
*ombre
x12 x13 x14 x15 x18 x19 x20 "11 "12 "13 "1& "17 "21
(alor I+ual
100,447 241,570 &8,48& 148,58& 111,475 22,418 &,800 80,290 &4,7&1 33,&89 112,000
)radiente reducido
1 2 -
)est*icci+nes Celda
$$15 $$1& $$17 $$18 $$19 $$20 $$21 $$22 $$23 $$24 $$25 $$14 $$13
*ombre
anta na .+tal %! El as+ .+tal %! endlet+n .+tal %! +st+n .+tal %! ansas .+tal %! %+s neles .+tal %! Glendale .+tal %! #acs+n6ille .+tal %! %ittle )+c .+tal %! B*ide+*t .+tal %! ac*ament+ .+tal %! lanta de aland .+tal %! lanta de Cincinati .+tal %!
(alor I+ual
Multi,licador de -a+ran+e
22418 &800 80290 100447 241570 &47&1 33&89 &848& 14858& 111475 112000 319958 &705&4
1/8700000048 0/7400000095 0/4900000095 1/&4999997&2 1/5599999428 0/2199999988 0/2199999988 1/5399999&19 1/5399999&19 1/5399999&19 0/15000000& 0 0
Microsoft Excel 12.0 Informe de l6mites Hoja de cálculo: [Caso Solution lus !"SE.xlsx#Informe de l6mites 1 Informe creado: 10$0%$201% 01:'&:'2 a.m.
Celda
Celda objeti5o *ombre
$$10 C+st+s
Celdas cambiantes Celda *ombre
$B$10 $C$10 $D$10 $E$10 $F$10 $G$10 $$10 $!$10 $#$10 $$10 $%$10 $'$10 $($10
x12 x13 x14 x15 x18 x19 x20 "11 "12 "13 "1& "17 "21
I+ual
1,173,304
I+ual
-6mite inferior
Celda objeti5o
100,447 241,570 &8,48& 148,58& 111,475 22,418 &,800 80,290 &4,7&1 33,&89 112,000
100,447 241,570 &8,48& 148,58& 111,475 22,418 &,800 80,290 &4,7&1 33,&89 112,000
1,173,304 1,173,304 1,173,304 1,173,304 1,173,304 1,173,304 1,173,304 1,173,304 1,173,304 1,173,304 1,173,304 1,173,304 1,173,304
-6mite su,erior
Celda objeti5o
1,173,304 1,173,304 100,447 1,173,304 241,570 1,173,304 &8,48& 1,173,304 148,58& 1,173,304 111,475 1,173,304 22,418 1,173,304 &,800 1,173,304 80,290 1,173,304 &4,7&1 1,173,304 33,&89 1,173,304 112,000 1,173,304
Microsoft Excel 12.0 Informe de sensibilidad Hoja de cálculo: [Caso Solution lus !"SE.xlsx#Hoja1 Informe creado: 10$0%$201% 01:2:% a.m.
Celdas cambiantes Celda
$B$10 $C$10 $D$10 $E$10 $F$10 $G$10 $$10 $!$10 $#$10 $$10 $%$10 $'$10 $($10
*ombre
x12 x13 x14 x15 x18 x19 x20 "11 "12 "13 "1& "17 "21
(alor I+ual
100,447 241,570 &8,48& 148,58& 111,475 22,418 &,800 80,290 &4,7&1 33,&89 112,000
)radiente reducido
Coeficiente objeti5o
"umento ,ermisible
"umento ,ermisible
1 2/0400000038 1E@030 1/300000004 2 2/0299999998 1E@030 1/54 1/&5 1E@030 1E@030 1/5& 1E@030 1E@030 1/54 1E@030 1E@030 1/54 1E@030 1E@030 1/54 1E@030 1E@030 1/87 1E@030 1E@030 - 0/7399999999 1/300000004 1E@030 0/49 1/54 1E@030 0/22 1E@030 1E@030 0/22 1E@030 1E@030 0/15 1E@030 1E@030
)est*icci+nes Celda
$$15 $$1& $$17 $$18 $$19 $$20 $$21 $$22 $$23 $$24 $$25 $$14 $$13
*ombre
anta na .+tal %! El as+ .+tal %! endlet+n .+tal %! +st+n .+tal %! ansas .+tal %! %+s neles .+tal %! Glendale .+tal %! #acs+n6ille .+tal %! %ittle )+c .+tal %! B*ide+*t .+tal %! ac*ament+ .+tal %! lanta de aland .+tal %! lanta de Cincinati .+tal %!
(alor I+ual
22418 &800 80290 100447 241570 &47&1 33&89 &848& 14858& 111475 112000 319958 &705&4
Sombra ,recio
1/87 0/74 0/49 1/&5 1/5& 0/22 0/22 1/54 1/54 1/54 0/15 0 0
7estricci3n lado derec8o
22418 &800 80290 100447 241570 &47&1 33&89 &848& 14858& 111475 112000 500000 0
"umento ,ermisible
180042 180042 180042 1E@030 1E@030 180042 180042 1E@030 1E@030 1E@030 180042 1E@030 &705&4
"umento ,ermisible
22418 &800 80290 100447 241570 &47&1 33&89 &848& 14858& 111475 112000 180042 1E@030
Microsoft Excel 12.0 Informe de sensibilidad Hoja de cálculo: [Caso Solution lus !"SE.xlsx#Hoja1 Informe creado: 11$0%$201% 12:'1:2 a.m.
Celdas cambiantes Celda
$B$10 $C$10 $D$10 $E$10 $F$10 $G$10 $$10 $!$10 $#$10 $$10 $%$10 $'$10 $($10
*ombre
x12 x13 x14 x15 x18 x19 x20 "11 "12 "13 "1& "17 "21
(alor I+ual
100,447 241,570 &8,48& 148,58& 111,475 22,419 &,800 80,290 &4,7&1 33,&89 112,000
)radiente reducido
Coeficiente objeti5o
"umento ,ermisible
"umento ,ermisible
1 2/0400000038 1E@030 1/300000004 2 2/0299999998 1E@030 1/54 1/&5 1E@030 1/&5 1/5& 1E@030 1/5& 1/54 1E@030 1/54 1/54 1E@030 1/54 1/54 1E@030 1/54 1/87 1E@030 1/87 - 0/7399999999 1/300000004 0/74 0/49 1/54 0/49 0/22 1E@030 0/22 0/22 1E@030 0/22 0/15 1E@030 0/15
)est*icci+nes Celda
$$14 $$15 $$1& $$17 $$18 $$19 $$20 $$21 $$22 $$23 $$24 $$25 $$2&
*ombre
lanta de Cincinati .+tal %! lanta de aland .+tal %! anta na .+tal %! El as+ .+tal %! endlet+n .+tal %! +st+n .+tal %! ansas .+tal %! %+s neles .+tal %! Glendale .+tal %! #acs+n6ille .+tal %! %ittle )+c .+tal %! B*ide+*t .+tal %! ac*ament+ .+tal %!
(alor I+ual
&705&4 319959 22419 &800 80290 100447 241570 &47&1 33&89 &848& 14858& 111475 112000
Sombra ,recio
0 0 1/87 1 0/49 1/&5 1/5& 0/22 0/22 1/54 1/54 1/54 0/15
7estricci3n lado derec8o
0 500000 22419 &800 80290 100447 241570 &47&1 33&89 &848& 14858& 111475 112000
"umento ,ermisible
&705&4 1E@030 180041 180041 180041 1E@030 1E@030 180041 180041 1E@030 1E@030 1E@030 180041
"umento ,ermisible
1E@030 180041 22419 &800 80290 100447 241570 &47&1 33&89 &848& 14858& 111475 112000
DATOS
US$/GL 1.20 1.65
COSTO DE PRODUCCIÓN
Planta de Cincinati Planta de Oakland Rutas
<12 0.% 2.0%
Costo ;ans7ote Costo Pod = ;ans.
<1& 0.& 2.0&
<1% 0.%5 1.65 100%%' 1&5,737/55
<15 0.&6 1.56 2%15'0 37&,849/20
<1 0.&% 1.5% 6%6 105,4&8/44
1/00
1/00
1/00
Restricciones
Planta de Cincinati Planta de Oakland Santa Ana El Paso Pendleton Houston ansas Los A! n"eles Glendale 3ackson4ille Little )ock id"e7ot Saca8ento
1/00
1/00
1/00
1/00
1/00
1/00
Santa Ana
1/00
<11 =11
El Paso
<12 =12
Pendleton
<1&
Plan
=1&
Houston
<1% =1% <15
ansas =15
<16
=16
<1'
=1'
<1
=1
<1(
=1(
<20
=20
<21
Los A! n"eles Glendale 3ackson4ille Little )ock id"e7ot Saca8ento =21
Pla
<1( 0.&% 1.5% 1%56 228,822/44
<20 0.&% 1.5% 111%'5 171,&71/50
=11 0.22 1.' 22%1( 41,923/53
=12 0.'% 0.'% 600 5,032/00
=1& 0.%( 0.%( 02(0 39,342/10
=16 0.22 0.22 6%'61 14,247/42
=1' 0.22 0.22 &&6( 7,411/58
1/00
1/00
1/00
1/00
Coeficientes 7estricciones
1/00
1/00 1/00 1/00
1/00 1/00 1/00 1/00 1/00 1/00
ta Cincina
ta Oakland
=21 0.15 0.15 112000 1&,800/00
Costos 1,173,305/8 990,523/00 9otal -I
6'056% 1/00 &1((5( 22%1( 600 02(0 100%%' 2%15'0 6%'61 &&6( 6%6 1%56 111%'5 1/00 112000
9otal -4
?< >< ?< ?< ?< ?< ?< ?< ?< ?< ?< ?< ?<
500000 500000 22419 &800 80290 100447 241570 &47&1 33&89 &848& 14858& 111475 112000
Hol+ura
-170,5&4/00 180,041/00 -