Pesquisa operacional exs Aula 5

Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original

5a
	Fabrica 1	Fabrica 2	Fabrica 3	Fabrica 4
	Local A	10	12	15	16	1
	Local B	14	12	13	18	1
	Local C	10	16	19	15	1
	Local D	14	12	13	15	1
	1	1	1	1
	x11	x12	x13	x14	x21	x22	x23	x24	x31	x32	x33	x34	x41	x42	x43	x44	minimizar
	variaveis	0	1	0	0	0	0	1	0	1	0	0	0	0	0	0	1	49.9999999998
	coeficiente	10	12	15	16	14	12	13	18	10	16	19	15	14	12	13	15
	Local A	1	1	1	1	0	0	0	0	0	0	0	0	0	0	0	0	1	=	1
	Local B	0	0	0	0	1	1	1	1	0	0	0	0	0	0	0	0	1	=	1
	Local C	0	0	0	0	0	0	0	0	1	1	1	1	0	0	0	0	1	=	1
	Local D	0	0	0	0	0	0	0	0	0	0	0	0	1	1	1	1	1	=	1
	Fabrica 1	1	0	0	0	1	0	0	0	1	0	0	0	1	0	0	0	1	=	1
	Fabrica 2	0	1	0	0	0	1	0	0	0	1	0	0	0	1	0	0	1	=	1
	Fabrica 3	0	0	1	0	0	0	1	0	0	0	1	0	0	0	1	0	1	=	1
	Fabrica 4	0	0	0	1	0	0	0	1	0	0	0	1	0	0	0	1	1	=	1
Relatório de sensibilidade 5a
	Microsoft Excel 12.0 Relatório de sensibilidade
	Planilha: [Pasta2]Plan1
	Relatório criado: 23/3/2015 20:25:47
	Células ajustáveis
	Final	Reduzido	Objetivo	Permissível	Permissível
	Célula	Nome	Valor	Custo	Coeficiente	Acréscimo	Decréscimo
	$B$10	variaveis x11	0	0	10	1.0000000003	0
	$C$10	variaveis x12	1	0	12.0000000003	0	1000000000000000000000000000000
	$D$10	variaveis x13	0	1.9999999999	14.9999999998	1000000000000000000000000000000	1.9999999999
	$E$10	variaveis x14	0	1.0000000003	16.0000000001	1000000000000000000000000000000	1.0000000003
	$F$10	variaveis x21	0	3.9999999999	14.0000000002	1000000000000000000000000000000	3.9999999999
	$G$10	variaveis x22	0	0	12.0000000003	1000000000000000000000000000000	0
	$H$10	variaveis x23	1	0	13	0	1000000000000000000000000000000
	$I$10	variaveis x24	0	3	18	1000000000000000000000000000000	3
	$J$10	variaveis x31	1	0	10.0000000003	0	1.0000000003
	$K$10	variaveis x32	0	3.9999999996	16.0000000001	1000000000000000000000000000000	3.9999999996
	$L$10	variaveis x33	0	6.0000000002	19.0000000003	1000000000000000000000000000000	6.0000000002
	$M$10	variaveis x34	0	0	15	1.0000000003	0
	$N$10	variaveis x41	0	4.0000000002	14.0000000002	1000000000000000000000000000000	4.0000000002
	$O$10	variaveis x42	0	0	12	1000000000000000000000000000000	0
	$P$10	variaveis x43	0	0	12.9999999999	1.9999999999	0
	$Q$10	variaveis x44	1	0	14.9999999998	0	1.9999999999
	Restrições
	Final	Sombra	Restrição	Permissível	Permissível
	Célula	Nome	Valor	Preço	Lateral R.H.	Acréscimo	Decréscimo
	$R$14	Local A minimizar	1	14.9999999997	1	0	0
	$R$15	Local B minimizar	1	14.9999999999	1	0	1
	$R$16	Local C minimizar	1	15	1	0	0
	$R$17	Local D minimizar	1	14.9999999997	1	0	1
	$R$18	Fabrica 1 minimizar	1	-4.9999999997	1	0	0
	$R$19	Fabrica 2 minimizar	1	-2.9999999995	1	0	0
	$R$20	Fabrica 3 minimizar	1	-1.9999999999	1	1	0
	$R$21	Fabrica 4 minimizar	1	0	1	0	1000000000000000000000000000000
5b
	Incorp. 1	Incorp. 2	Incorp. 3	Incorp. 4	Incorp. 5
	Terreno A	19	19	29	23	24	1
	Terreno B	23	21	27	19	25	1
	Terreno C	19	19	22	0	20	1
	Terreno D	23	0	19	21	18	1
	1	1	1	1	1
	x11	x12	x13	x14	x15	x21	x22	x23	x24	x25	x31	x32	x33	x34	x35	x41	x42	x43	x44	x45	maximizar
	variaveis	0	0	1	0	0	0	0	0	0	1	0	1	0	0	-0	1	0	0	0	0	96
	coeficiente	19	19	29	23	24	23	21	27	19	25	19	19	22	0	20	23	0	19	21	18
	Terreno A	1	1	1	1	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	=	1
	Terreno B	0	0	0	0	0	1	1	1	1	1	0	0	0	0	0	0	0	0	0	0	1	=	1
	Terreno C	0	0	0	0	0	0	0	0	0	0	1	1	1	1	1	0	0	0	0	0	1	=	1
	Terreno D	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	1	1	1	1	1	=	1
	Incorp. 1	1	0	0	0	0	1	0	0	0	0	1	0	0	0	0	1	0	0	0	0	1	<=	1
	Incorp. 2	0	1	0	0	0	0	1	0	0	0	0	1	0	0	0	0	1	0	0	0	1	<=	1
	Incorp. 3	0	0	1	0	0	0	0	1	0	0	0	0	1	0	0	0	0	1	0	0	1	<=	1
	Incorp. 4	0	0	0	1	0	0	0	0	1	0	0	0	0	1	0	0	0	0	1	0	0	<=	1
	Incorp. 5	0	0	0	0	1	0	0	0	0	1	0	0	0	0	1	0	0	0	0	1	1	<=	1
Relatório de sensibilidade 5b
	Microsoft Excel 12.0 Relatório de sensibilidade
	Planilha: [Pasta2]Plan2
	Relatório criado: 23/3/2015 20:50:42
	Células ajustáveis
	Final	Reduzido	Objetivo	Permissível	Permissível
	Célula	Nome	Valor	Custo	Coeficiente	Acréscimo	Decréscimo
	$B$10	variaveis x11	0	-4.0000000014	19.0000000003	4.0000000014	1000000000000000000000000000000
	$C$10	variaveis x12	0	-4.0000000013	19.0000000003	4.0000000013	1000000000000000000000000000000
	$D$10	variaveis x13	1	0	29.0000000001	1000000000000000000000000000000	2.9999999985
	$E$10	variaveis x14	0	0	23.0000000016	2.9999999985	0
	$F$10	variaveis x15	0	0	24.0000000019	0	1000000000000000000000000000000
	$G$10	variaveis x21	0	-0.9999999984	23.0000000016	0.9999999984	1000000000000000000000000000000
	$H$10	variaveis x22	0	-2.9999999989	21.000000001	2.9999999989	1000000000000000000000000000000
	$I$10	variaveis x23	0	-2.9999999985	27	2.9999999985	1000000000000000000000000000000
	$J$10	variaveis x24	0	-4.9999999995	19.0000000003	4.9999999995	1000000000000000000000000000000
	$K$10	variaveis x25	1	0	25.0000000001	1000000000000000000000000000000	0.9999999984
	$L$10	variaveis x31	0	0	19.0000000003	2.0000000005	0
	$M$10	variaveis x32	1	0	19.0000000001	0	2.0000000005
	$N$10	variaveis x33	0	-2.999999999	21.9999999999	2.999999999	1000000000000000000000000000000
	$O$10	variaveis x34	0	-19.0000000002	0	19.0000000002	1000000000000000000000000000000
	$P$10	variaveis x35	-0	0	20.0000000007	0.9999999984	0
	$Q$10	variaveis x41	1	0	23.0000000001	1000000000000000000000000000000	2.0000000005
	$R$10	variaveis x42	0	-23.0000000001	0	23.0000000001	1000000000000000000000000000000
	$S$10	variaveis x43	0	-9.9999999984	19.0000000003	9.9999999984	1000000000000000000000000000000
	$T$10	variaveis x44	0	-2.0000000005	20.9999999996	2.0000000005	1000000000000000000000000000000
	$U$10	variaveis x45	0	-6.0000000005	18	6.0000000005	1000000000000000000000000000000
	Restrições
	Final	Sombra	Restrição	Permissível	Permissível
	Célula	Nome	Valor	Preço	Lateral R.H.	Acréscimo	Decréscimo
	$V$14	Terreno A maximizar	1	23.0000000015	1	1	0
	$V$15	Terreno B maximizar	1	23.9999999997	1	0	1
	$V$16	Terreno C maximizar	1	19.0000000001	1	0	1
	$V$17	Terreno D maximizar	1	22.9999999999	1	0	1
	$V$18	Incorp. 1 maximizar	1	0	1	1	0
	$V$19	Incorp. 2 maximizar	1	0	1	1000000000000000000000000000000	0
	$V$20	Incorp. 3 maximizar	1	5.9999999986	1	0	1
	$V$21	Incorp. 4 maximizar	0	0	1	1000000000000000000000000000000	1
	$V$22	Incorp. 5 maximizar	1	1.0000000004	1	1	0
Plan3