Superfície de custos

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

Gráfico
	397.6049124822	312.4512872237	280.9389342811	271.5577064276	273.4360039511	281.8209985661	294.3048973737
	281.6011960276	236.3893050414	226.2130094455	230.084665898	240.9896883841	255.9172318373	273.3603638256
	290.1587380854	248.4434180674	240.0848450815	245.0694091278	256.7256634222	272.1943568629	290.0458443347
	310.0003094541	268.3335479356	260.0001653979	265.0001353062	276.6667816745	292.1429575358	310.0000893682
	330.0000000769	288.3333333866	280.0000000411	285.0000000336	296.6666666952	312.1428571678	330.0000000222
100
150
200
250
300
350
400
Estoque de segurança (unidades)
Custo total (R$/período)
Lote (unidades)
Custos totais por período
Dados
	CT		Q							Q	Tamanho do lote
			100	150	200	250	300	350	400	s	Ponto de reposição
	ES	0	398	312	281	272	273	282	294	ES	Estoque de segurança
		20	282	236	226	230	241	256	273	Pm	Perda mémês por ciclo de reposição
		40	290	248	240	245	257	272	290	z	Coeficiente de segurança
		60	310	268	260	265	277	292	310	P1	Proporção de ciclos com atendimento integral
		80	330	288	280	285	297	312	330	P2	Proporção de demanda atendida
										CT	Custo total por período
	
	Custo unitário de pedido (cp; R$/pedido)				100	Demanda (Dm; unidades/mês)				200	Variáveis de decisão independentes
	Custo unitário de estocagem (ce; R$/unidade/mês)				1	Desvio-padrão da demanda (sigma; un./mês)				30	Valores ótimos pelas fórmulas (3 iterações)
	Custo unitário de falta (cf; R$/unidade)				15	Tempo de suprimento (L; meses)				0.2	Valores ótimos pelo Solver
	226.13	97.20	123.25	5.68	205.37	60.18	20.18	0.3898	1.504	0.1288	0.933686	0.0291	99.810566932%
	226.14	97.16	123.54	5.44	205.48	60.43	20.43	0.373	1.523	0.1251	0.936091	0.0278	99.818688869%	1.0292662	226.14
	CT	CPedido	CEstocagem	CFalta	Q	s	ES	Pm	z	f(z)	F(z) =P1	I(z)	P2	Ciclo (meses)	CT
	724.85	166.11	50.40	508.34	100.00	20.00	-20.00	20.402	-1.491	0.1313	0.068019	1.5206	83.055380085%	0.6020080	724.85
	397.60	189.84	55.35	152.41	100.00	40.00	0.00	5.352	0.000	0.3989	0.500000	0.3989	94.919552138%	0.5267619	397.60
	281.60	199.20	70.40	12.00	100.00	60.00	20.00	0.402	1.491	0.1313	0.931981	0.0299	99.600014148%	0.5020080	281.60
	290.16	199.99	90.01	0.16	100.00	80.00	40.00	0.005	2.981	0.0047	0.998565	0.0004	99.994526283%	0.5000274	290.16
	310.00	200.00	110.00	0.00	100.00	100.00	60.00	0.000	4.472	0.0000	0.999996	0.0000	99.999989329%	0.5000001	310.00
	330.00	200.00	130.00	0.00	100.00	120.00	80.00	0.000	5.963	0.0000	1.000000	0.0000	99.999999997%	0.5000000	330.00
	551.95	117.37	75.40	359.18	150.00	20.00	-20.00	20.402	-1.491	0.1313	0.068019	1.5206	88.027346514%	0.8520080	551.95
	312.45	128.74	80.35	103.36	150.00	40.00	0.00	5.352	0.000	0.3989	0.500000	0.3989	96.554689016%	0.7767619	312.45
	236.39	132.98	95.40	8.01	150.00	60.00	20.00	0.402	1.491	0.1313	0.931981	0.0299	99.732986760%	0.7520080	236.39
	248.44	133.33	115.01	0.11	150.00	80.00	40.00	0.005	2.981	0.0047	0.998565	0.0004	99.996350789%	0.7500274	248.44
	268.33	133.33	135.00	0.00	150.00	100.00	60.00	0.000	4.472	0.0000	0.999996	0.0000	99.999992886%	0.7500001	268.33
	288.33	133.33	155.00	0.00	150.00	120.00	80.00	0.000	5.963	0.0000	1.000000	0.0000	99.999999998%	0.7500000	288.33
	468.84	90.74	100.40	277.70	200.00	20.00	-20.00	20.402	-1.491	0.1313	0.068019	1.5206	90.743446105%	1.1020080	468.84
	280.94	97.39	105.35	78.19	200.00	40.00	0.00	5.352	0.000	0.3989	0.500000	0.3989	97.393566830%	1.0267619	280.94
	226.21	99.80	120.40	6.01	200.00	60.00	20.00	0.402	1.491	0.1313	0.931981	0.0299	99.799606301%	1.0020080	226.21
	240.08	100.00	140.01	0.08	200.00	80.00	40.00	0.005	2.981	0.0047	0.998565	0.0004	99.997263067%	1.0000274	240.08
	260.00	100.00	160.00	0.00	200.00	100.00	60.00	0.000	4.472	0.0000	0.999996	0.0000	99.999994665%	1.0000001	260.00
	280.00	100.00	180.00	0.00	200.00	120.00	80.00	0.000	5.963	0.0000	1.000000	0.0000	99.999999999%	1.0000000	280.00
	425.71	73.96	125.40	226.35	250.00	20.00	-20.00	20.402	-1.491	0.1313	0.068019	1.5206	92.455076910%	1.3520080	425.71
	271.56	78.32	130.35	62.88	250.00	40.00	0.00	5.352	0.000	0.3989	0.500000	0.3989	97.903926915%	1.2767619	271.56
	230.08	79.87	145.40	4.81	250.00	60.00	20.00	0.402	1.491	0.1313	0.931981	0.0299	99.839620763%	1.2520080	230.08
	245.07	80.00	165.01	0.07	250.00	80.00	40.00	0.005	2.981	0.0047	0.998565	0.0004	99.997810441%	1.2500274	245.07
	265.00	80.00	185.00	0.00	250.00	100.00	60.00	0.000	4.472	0.0000	0.999996	0.0000	99.999995732%	1.2500001	265.00
	285.00	80.00	205.00	0.00	250.00	120.00	80.00	0.000	5.963	0.0000	1.000000	0.0000	99.999999999%	1.2500000	285.00
	403.85	62.42	150.40	191.03	300.00	20.00	-20.00	20.402	-1.491	0.1313	0.068019	1.5206	93.632493513%	1.6020080	403.85
	273.44	65.50	155.35	52.59	300.00	40.00	0.00	5.352	0.000	0.3989	0.500000	0.3989	98.247148923%	1.5267619	273.44
	240.99	66.58	170.40	4.01	300.00	60.00	20.00	0.402	1.491	0.1313	0.931981	0.0299	99.866314902%	1.5020080	240.99
	256.73	66.67	190.01	0.05	300.00	80.00	40.00	0.005	2.981	0.0047	0.998565	0.0004	99.998175361%	1.5000274	256.73
	276.67	66.67	210.00	0.00	300.00	100.00	60.00	0.000	4.472	0.0000	0.999996	0.0000	99.999996443%	1.5000001	276.67
	296.67	66.67	230.00	0.00	300.00	120.00	80.00	0.000	5.963	0.0000	1.000000	0.0000	99.999999999%	1.5000000	296.67
	394.64	54.00	175.40	165.24	350.00	20.00	-20.00	20.402	-1.491	0.1313	0.068019	1.5206	94.492034431%	1.8520080	394.64
	281.82	56.28	180.35	45.19	350.00	40.00	0.00	5.352	0.000	0.3989	0.500000	0.3989	98.493784546%	1.7767619	281.82
	255.92	57.08	195.40	3.44	350.00	60.00	20.00	0.402	1.491	0.1313	0.931981	0.0299	99.885390885%	1.7520080	255.92
	272.19	57.14	215.01	0.05	350.00	80.00	40.00	0.005	2.981	0.0047	0.998565	0.0004	99.998436020%	1.7500274	272.19
	292.14	57.14	235.00	0.00	350.00	100.00	60.00	0.000	4.472	0.0000	0.999996	0.0000	99.999996951%	1.7500001	292.14
	312.14	57.14	255.00	0.00	350.00	120.00	80.00	0.000	5.963	0.0000	1.000000	0.0000	99.999999999%	1.7500000	312.14
	393.56	47.57	200.40	145.59	400.00	20.00	-20.00	20.402	-1.491	0.1313	0.068019	1.5206	95.147118245%	2.1020080	393.56
	294.30	49.34	205.35	39.61	400.00	40.00	0.00	5.352	0.000	0.3989	0.500000	0.3989	98.679575423%	2.0267619	294.30
	273.36	49.95	220.40	3.01	400.00	60.00	20.00	0.402	1.491	0.1313	0.931981	0.0299	99.899702656%	2.0020080	273.36
	290.05	50.00	240.01	0.04	400.00	80.00	40.00	0.005	2.981	0.0047	0.998565	0.0004	99.998631515%	2.0000274	290.05
	310.00	50.00	260.00	0.00	400.00	100.00	60.00	0.000	4.472	0.0000	0.999996	0.0000	99.999997332%	2.0000001	310.00
	330.00	50.00	280.00	0.00	400.00	120.00	80.00	0.000	5.963	0.0000	1.000000	0.0000	99.999999999%	2.0000000	330.00
															0.00
															0.00
															0.00
															0.00