05 - Ponto de Pedido Probabilístico

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

Modelo Q
		Simulação de Controle de Estoques com Variação Probabilística de Demanda
		Demanda Anual (D)				Lead time (Tempo de Entrega do Produto)					Custo de Uma Ordem de Compra (Co)
		5330	unidades			21					R$ 138.00
				(10 a 10000)				(1 a 90 dias)					(10 a 500)
		Desvio padrão da demanda diária				Nível de confiabilidade do atendimento					Custo unitário de compra do produto (Cc)
		8	unidades			86	%				R$ 1.00
				(1 a 20)				(50 a 99%)			10		(1 a 100)
						Dias de trabalho por ano
						270
	
	
											Modelo Q de Estoque
											1212.88	Q - Lote Econômico de Compra
											20	Demanda Diária
											4.39	Ordens de Compra por Ano
											61.44	Tempo entre duas ordens
											460	Ponto de encomenda
											40	Estoque de Segurança
	
											R$ 1,212.88	Custo Total Anual
	
	
	
	
	
	
				Modelo: Demanda constante
			Time	1212.8808680163		Ponto de Encomenda Deterministico
			0	1192.8808680163		460
			1	1172.8808680163		460
			2	1152.8808680163		460
			3	1132.8808680163		460
			4	1112.8808680163		460
			5	1092.8808680163		460
			6	1072.8808680163		460
			7	1052.8808680163		460
			8	1032.8808680163		460
			9	1012.8808680163		460
			10	992.8808680163		460
			11	972.8808680163		460
			12	952.8808680163		460
			13	932.8808680163		460
			14	912.8808680163		460
			15	892.8808680163		460
			16	872.8808680163		460
			17	852.8808680163		460
			18	832.8808680163		460
			19	812.8808680163		460
			20	792.8808680163		460
			21	772.8808680163		460
			22	752.8808680163		460
			23	732.8808680163		460
			24	712.8808680163		460
			25	692.8808680163		460
			26	672.8808680163		460
			27	652.8808680163		460
			28	632.8808680163		460
			29	612.8808680163		460
			30	592.8808680163		460
			31	572.8808680163		460
			32	552.8808680163		460
			33	532.8808680163		460
			34	512.8808680163		460
			35	492.8808680163		460
			36	472.8808680163		460
			37	452.8808680163		460
			38	432.8808680163		460
			39	412.8808680163		460
			40	392.8808680163		460
			41	372.8808680163		460
			42	352.8808680163		460
			43	332.8808680163		460
			44	312.8808680163		460
			45	292.8808680163		460
			46	272.8808680163		460
			47	252.8808680163		460
			48	232.8808680163		460
			49	212.8808680163		460
			50	192.8808680163		460
			51	172.8808680163		460
			52	152.8808680163		460
			53	132.8808680163		460
			54	112.8808680163		460
			55	92.8808680163		460
			56	72.8808680163		460
			57	52.8808680163		460
			58	32.8808680163		460
			59	12.8808680163		460
			60	1212.8808680163		460
			61	1192.8808680163		460
			62	1172.8808680163		460
			63	1152.8808680163		460
			64	1132.8808680163		460
			65	1112.8808680163		460
			66	1092.8808680163		460
			67	1072.8808680163		460
			68	1052.8808680163		460
			69	1032.8808680163		460
			70	1012.8808680163		460
			71	992.8808680163		460
			72	972.8808680163		460
			73	952.8808680163		460
			74	932.8808680163		460
			75	912.8808680163		460
			76	892.8808680163		460
			77	872.8808680163		460
			78	852.8808680163		460
			79	832.8808680163		460
			80	812.8808680163		460
			81	792.8808680163		460
			82	772.8808680163		460
			83	752.8808680163		460
			84	732.8808680163		460
			85	712.8808680163		460
			86	692.8808680163		460
			87	672.8808680163		460
			88	652.8808680163		460
			89	632.8808680163		460
			90	612.8808680163		460
			91	592.8808680163		460
			92	572.8808680163		460
			93	552.8808680163		460
			94	532.8808680163		460
			95	512.8808680163		460
			96	492.8808680163		460
			97	472.8808680163		460
			98	452.8808680163		460
			99	432.8808680163		460
			100	412.8808680163		460
			101	392.8808680163		460
			102	372.8808680163		460
			103	352.8808680163		460
			104	332.8808680163		460
			105	312.8808680163		460
			106	292.8808680163		460
			107	272.8808680163		460
			108	252.8808680163		460
			109	232.8808680163		460
			110	212.8808680163		460
			111	192.8808680163		460
			112	172.8808680163		460
			113	152.8808680163		460
			114	132.8808680163		460
			115	112.8808680163		460
			116	92.8808680163		460
			117	72.8808680163		460
			118	52.8808680163		460
			119	32.8808680163		460
			120	12.8808680163		460
			121	1212.8808680163		460
			122	1192.8808680163		460
			123	1172.8808680163		460
			124	1152.8808680163		460
			125	1132.8808680163		460
			126	1112.8808680163		460
			127	1092.8808680163		460
			128	1072.8808680163		460
			129	1052.8808680163		460
			130	1032.8808680163		460
			131	1012.8808680163		460
			132	992.8808680163		460
			133	972.8808680163		460
			134	952.8808680163		460
			135	932.8808680163		460
			136	912.8808680163		460
			137	892.8808680163		460
			138	872.8808680163		460
			139	852.8808680163		460
			140	832.8808680163		460
			141	812.8808680163		460
			142	792.8808680163		460
			143	772.8808680163		460
			144	752.8808680163		460
			145	732.8808680163		460
			146	712.8808680163		460
			147	692.8808680163		460
			148	672.8808680163		460
			149	652.8808680163		460
			150	632.8808680163		460
			151	612.8808680163		460
			152	592.8808680163		460
			153	572.8808680163		460
			154	552.8808680163		460
			155	532.8808680163		460
			156	512.8808680163		460
			157	492.8808680163		460
			158	472.8808680163		460
			159	452.8808680163		460
			160	432.8808680163		460
			161	412.8808680163		460
			162	392.8808680163		460
			163	372.8808680163		460
			164	352.8808680163		460
			165	332.8808680163		460
			166	312.8808680163		460
			167	292.8808680163		460
			168	272.8808680163		460
			169	252.8808680163		460
			170	232.8808680163		460
			171	212.8808680163		460
			172	192.8808680163		460
			173	172.8808680163		460
			174	152.8808680163		460
			175	132.8808680163		460
			176	112.8808680163		460
			177	92.8808680163		460
			178	72.8808680163		460
			179	52.8808680163		460
			180	32.8808680163		460
			181	12.8808680163		460
			182	1212.8808680163		460
			183	1192.8808680163		460
			184	1172.8808680163		460
			185	1152.8808680163		460
			186	1132.8808680163		460
			187	1112.8808680163		460
			188	1092.8808680163		460
			189	1072.8808680163		460
			190	1052.8808680163		460
			191	1032.8808680163		460
			192	1012.8808680163		460
			193	992.8808680163		460
			194	972.8808680163		460
			195	952.8808680163		460
			196	932.8808680163		460
			197	912.8808680163		460
			198	892.8808680163		460
			199	872.8808680163		460
			200	852.8808680163		460
			201	832.8808680163		460
			202	812.8808680163		460
			203	792.8808680163		460
			204	772.8808680163		460
			205	752.8808680163		460
			206	732.8808680163		460
			207	712.8808680163		460
			208	692.8808680163		460
			209	672.8808680163		460
			210	652.8808680163		460
			211	632.8808680163		460
			212	612.8808680163		460
			213	592.8808680163		460
			214	572.8808680163		460
			215	552.8808680163		460
			216	532.8808680163		460
			217	512.8808680163		460
			218	492.8808680163		460
			219	472.8808680163		460
			220	452.8808680163		460
			221	432.8808680163		460
			222	412.8808680163		460
			223	392.8808680163		460
			224	372.8808680163		460
			225	352.8808680163		460
			226	332.8808680163		460
			227	312.8808680163		460
			228	292.8808680163		460
			229	272.8808680163		460
			230	252.8808680163		460
			231	232.8808680163		460
			232	212.8808680163		460
			233	192.8808680163		460
			234	172.8808680163		460
			235	152.8808680163		460
			236	132.8808680163		460
			237	112.8808680163		460
			238	92.8808680163		460
			239	72.8808680163		460
			240	52.8808680163		460
			241	32.8808680163		460
			242	12.8808680163		460
			243	1212.8808680163		460
			244	1192.8808680163		460
			245	1172.8808680163		460
			246	1152.8808680163		460
			247	1132.8808680163		460
			248	1112.8808680163		460
			249	1092.8808680163		460
			250	1072.8808680163		460
			251	1052.8808680163		460
			252	1032.8808680163		460
			253	1012.8808680163		460
			254	992.8808680163		460
			255	972.8808680163		460
			256	952.8808680163
460
			257	932.8808680163		460
			258	912.8808680163		460
			259	892.8808680163		460
			260	872.8808680163		460
			261	852.8808680163		460
			262	832.8808680163		460
			263	812.8808680163		460
			264	792.8808680163		460
			265	772.8808680163		460
			266	752.8808680163		460
			267	732.8808680163		460
			268	712.8808680163		460
			269	692.8808680163		460
			270	672.8808680163		460
			271	652.8808680163		460
			272	632.8808680163		460
			273	612.8808680163		460
			274	592.8808680163		460
			275	572.8808680163		460
			276	552.8808680163		460
			277	532.8808680163		460
			278	512.8808680163		460
			279	492.8808680163		460
			280	472.8808680163		460
			281	452.8808680163		460
			282	432.8808680163		460
			283	412.8808680163		460
			284	392.8808680163		460
			285	372.8808680163		460
			286	352.8808680163		460
			287	332.8808680163		460
			288	312.8808680163		460
			289	292.8808680163		460
			290	272.8808680163		460
			291	252.8808680163		460
			292	232.8808680163		460
			293	212.8808680163		460
			294	192.8808680163		460
			295	172.8808680163		460
			296	152.8808680163		460
			297	132.8808680163		460
			298	112.8808680163		460
			299	92.8808680163		460
			300	72.8808680163		460
			301	52.8808680163		460
			302	32.8808680163		460
			303	12.8808680163		460
			304	1212.8808680163		460
			305	1192.8808680163		460
			306	1172.8808680163		460
			307	1152.8808680163		460
			308	1132.8808680163		460
			309	1112.8808680163		460
			310	1092.8808680163		460
			311	1072.8808680163		460
			312	1052.8808680163		460
			313	1032.8808680163		460
			314	1012.8808680163		460
			315	992.8808680163		460
			316	972.8808680163		460
			317	952.8808680163		460
			318	932.8808680163		460
			319	912.8808680163		460
			320	892.8808680163		460
			321	872.8808680163		460
			322	852.8808680163		460
			323	832.8808680163		460
			324	812.8808680163		460
			325	792.8808680163		460
			326	772.8808680163		460
			327	752.8808680163		460
			328	732.8808680163		460
			329	712.8808680163		460
			330	692.8808680163		460
			331	672.8808680163		460
			332	652.8808680163		460
			333	632.8808680163		460
			334	612.8808680163		460
			335	592.8808680163		460
			336	572.8808680163		460
			337	552.8808680163		460
			338	532.8808680163		460
			339	512.8808680163		460
			340	492.8808680163		460
			341	472.8808680163		460
			342	452.8808680163		460
			343	432.8808680163		460
			344	412.8808680163		460
			345	392.8808680163		460
			346	372.8808680163		460
			347	352.8808680163		460
			348	332.8808680163		460
			349	312.8808680163		460
			350	292.8808680163		460
			351	272.8808680163		460
			352	252.8808680163		460
			353	232.8808680163		460
			354	212.8808680163		460
			355	192.8808680163		460
			356	172.8808680163		460
			357	152.8808680163		460
			358	132.8808680163		460
			359	112.8808680163		460
			360	92.8808680163		460
			361	72.8808680163		460
			362	52.8808680163		460
			363	32.8808680163		460
			364	12.8808680163		460
			365			460
Modelo Q
	
Modelo: Demanda constante
Ponto de Encomenda Deterministico
Dias
Nível de Estoques
Ciclo dos Estoques
Total cost
	
	
		5330	Demanda Anual (D)
	
	
		R$ 138.00	Custo da Ordem (Co)
	
	
		R$ 1.00	Custo Unitário (Cc)
	
	
		Custo Total	EOQ
		R$ 1,212.88	1213
	
	
	
	
	
	
	
	
	
	
		Q	Co
		100	$7,355.40
		200	$3,677.70	Cc
		300	$2,451.80	$50.00
		400	$1,838.85	$100.00
		500	$1,471.08	$150.00
		600	$1,225.90	$200.00
		700	$1,050.77	$250.00	TC
		800	$919.42	$300.00	$7,405.40
		900	$817.27	$350.00	$3,777.70
		1000	$735.54	$400.00	$2,601.80
		1100	$668.67	$450.00	$2,038.85
		1200	$612.95	$500.00	$1,721.08
		1300	$565.80	$550.00	$1,525.90
		1400	$525.39	$600.00	$1,400.77
		1500	$490.36	$650.00	$1,319.42
		1600	$459.71	$700.00	$1,267.27
		1700	$432.67	$750.00	$1,235.54
		1800	$408.63	$800.00	$1,218.67
		1900	$387.13	$850.00	$1,212.95
		2000	$367.77	$900.00	$1,215.80
		2100	$350.26	$950.00	$1,225.39
		2200	$334.34	$1,000.00	$1,240.36
		2300	$319.80	$1,050.00	$1,259.71
		2400	$306.47	$1,100.00	$1,282.67
		2500	$294.22	$1,150.00	$1,308.63
		2600	$282.90	$1,200.00	$1,337.13
		2700	$272.42	$1,250.00	$1,367.77
		2800	$262.69	$1,300.00	$1,400.26
		2900	$253.63	$1,350.00	$1,434.34
		3000	$245.18	$1,400.00	$1,469.80
				$1,450.00	$1,506.47
				$1,500.00	$1,544.22
					$1,582.90
					$1,622.42
					$1,662.69
					$1,703.63
					$1,745.18
LEMC:
O nível de serviço pode ser interpretado como o nível de confiança no atendimento das necessidades de compra de todos os posssíveis fregueses.
Aldo:
A demanda diária é a razão da demanda anual pelo número de dias de trabalho no ano. Suposta Constante. Valor arredondado.
Aldo:
Para o nível de serviço desejado (confiabilidade), utiliza o valor de "z" apurado, multiplica pelo Desvio Padrão, obtendo um valor que, multiplicado pela raiz do Lead time dá o estoque de segurança para aquele nível de confiabilidade. Valor Arredondado.
Aldo:
Valor Arredondado.
Total cost
	7355.4	350	7705.4
	3677.7	700	4377.7
	2451.8	1050	3501.8
	1838.85	1400	3238.85
	1471.08	1750	3221.08
	1225.9	2100	3325.9
	1050.7714285714	2450	3500.7714285714
	919.425	2800	3719.425
	817.2666666667	3150	3967.2666666667
	735.54	3500	4235.54
	668.6727272727	3850	4518.6727272727
	612.95	4200	4812.95
	565.8	4550	5115.8
	525.3857142857	4900	5425.3857142857
	490.36	5250	5740.36
	459.7125	5600	6059.7125
	432.6705882353	5950	6382.6705882353
	408.6333333333	6300	6708.6333333333
	387.1263157895	6650	7037.1263157895
	367.77	7000	7367.77
	350.2571428571	7350	7700.2571428571
	334.3363636364	7700	8034.3363636364
	319.8	8050	8369.8
	306.475	8400	8706.475
	294.216	8750	9044.216
	282.9	9100	9382.9
	272.4222222222	9450	9722.4222222222
	262.6928571429	9800	10062.6928571429
	253.6344827586	10150	10403.6344827586
	245.18	10500	10745.18
Co
Cc
TC
Order Quantity (in hundreds of units)
Total Cost