Tabela prova uan 2 - ATUALIZADA

Prévia do material em texto

QUESTAO 01
	SKU	UNIDADE	CONSUMO ANUAL		PU	CA		% ITEM	%ACUM	CLASSIFICAÇÃO
	1	Kg	12,000		R$ 5.60	67,200.00		37.06%	37.06%	A
	2	kg	6,780		R$ 4.50	30,510.00		16.83%	54%	A
	3	kg	7,000		R$ 4.20	29,400.00		16%	70%	A
	4	kg	5,600		R$ 3.45	19,320.00		11%	81%	B
	5	kg	3,220		R$ 3.15	10,143.00		6%	86%	B
	6	kg	3,000		R$ 2.50	7,500.00		4%	90%	B
	7	kg	980		R$ 7	6,860.00		4%	94%	B
	8	kg	670		R$ 9	6,030.00		3%	98%	C 
	8	kg	1,250		R$ 2.10	2,625.00		1%	99%	C
	8	kg	400		R$ 4.30	1,720.00		1%	100%	C
	TOTAL DE ITENS: 10				TOTAL R$181.308,00			100%
	CLASSIFICAÇÃO					% SKU	ACUM %	VALOR MENETARIO		R$%
	A		3	70%	75%	20%	70%	127,110		70.00%
	B		4	94%	20%	30%	94%	43,823		25.17%
	C		3	100%	5%	50%	100%	10,375		5.72%
	TOTAL:		10					181,308.00
QUESTAO 02
	% ITEM	%ACUM
	37.06%	37.06%
	16.83%	54%
	16%	70%
	11%	81%
	6%	86%
	4%	90%
	4%	94%
	3%	98%
	1%	99%
	1%	100%
%ACUM	0.3706	0.1683	0.16	0.11	0.06	0.04	0.04	0.03	0.01	0.01	0.3706	0.54	0.7	0.8	1	0.86	0.9	0.94	0.98	0.99	1.0	
QUESTAO 03
	ITEM DE MAIOR ESTOQUE 
	EM		4,182.91	EM	4,182.91	0
	LEC		3,249.61		3,996.25	1
	TR		5 DIAS		3,809.59	2
	Em		933.3		3,622.93	3
	NR		1,866.60		3,436.27	4
	CMD		186.66	LEC	3,249.61	5
	QR		95,200		3,062.95	6
	IA		17 DIAS		2,876.29	7
	MÊS EQUIVALENCIA		2 MÊSES		2,689.63	8
	APROX./ARREDOND				2,502.97	9
					2,316.31	10
	3,996.25				2,129.65	11
				NR	1,942.99	12
					1,756.33	13
					1,569.67	14
					1,383.01	15
					1,196.35	16
				Em	1,009.69	17
					823.03	18
					636.37	19
					449.71	20
				CMD	263.05	21
					76.39	22
					4,182.91	22
					3,996.25	23
					3,809.59	24
					3,622.93	25
					3,436.27	26
					3,249.61	27
					3,062.95	28
					2,876.29	29
					2,689.63	30
					2,502.97	31
					2,316.31	32
					2,129.65	33
					1,942.99	34
					1,756.33	35
					1,569.67	36
					1,383.01	37
					1,196.35	38
					1,009.69	39
					823.03	40
					636.37	41
					449.71	42
					263.05	43
					76.39	44
					4,182.91	44
					3,996.25	45
					3,809.59	46
					3,622.93	47
					3,436.27	48
					3,249.61	49
					3,062.95	50
					2,876.29	51
					2,689.63	52
					2,502.97	53
					2,316.31	54
					2,129.65	55
					1,942.99	56
					1,756.33	57
					1,569.67	58
					1,383.01	59
					1,196.35	60
					1,009.69	61
					823.03	62
					636.37	63
					449.71	64
					263.05	65
					76.39	66
4182.91	3996.25	3809.59	3622.93	3436.27	3249.61	3062.95	2876.29	2689.63	2502.97	2316.31	2129.65	1942.99	1756.33	1569.67	1383.01	1196.35	1009.69	823.03	636.37	449.71	263.05	76.3899999999994	4182.91	3996.25	3809.59	3622.93	3436.27	3249.61	3062.95	2876.29	2689.63	2502.97	2316.31	2129.65	1942.99	1756.33	1569.67	1383.01	1196.35	1009.69	823.03	636.37	449.71	263.05	76.3899999999994	4182.91	3996.25	3809.59	3622.93	3436.27	3249.61	3062.95	2876.29	2689.63	2502.97	2316.31	2129.65	1942.99	1756.33	1569.67	1383.01	1196.35	1009.69	823.03	636.37	449.71	263.05	76.3899999999994	0.0	1.0	2.0	3.0	4.0	5.0	6.0	7.0	8.0	9.0	10.0	11.0	12.0	13.0	14.0	15.0	16.0	17.0	18.0	19.0	20.0	21.0	22.0	22.0	23.0	24.0	25.0	26.0	27.0	28.0	29.0	30.0	31.0	32.0	33.0	34.0	35.0	36.0	37.0	38.0	39.0	40.0	41.0	42.0	43.0	44.0	44.0	45.0	46.0	47.0	48.0	49.0	50.0	51.0	52.0	53.0	54.0	55.0	56.0	57.0	58.0	59.0	60.0	61.0	62.0	63.0	64.0	65.0	66.0	
QUESTAO 05
	ITEM MAIOR DE ESTOQUE
	EM			4,182.92			CT	4,548.42	0
	LEC			3,349.61				4,361.76	1
	TR			5 DIAS				4,175.10	2
	Em			933.03				3,988.44	3
	NR			1,866.06				3,801.78	4
	CMD			186.66				3,615.12	5
	QR			95,200				3,428.46	6
	IA			17 DIAS				3,241.80	7
	CUSTO DE MANUTENCAO ESTOQUE			2,274.72				3,055.14	8
	CUSTO PEDIDO DE COMPRA			2,273.70				2,868.48	9
	CUSTO TOTAL			4,548.42				2,681.82	10
								2,495.16	11
							CME	2,308.50	12
							CPM	2,121.84	13
	4,361.76							1,935.18	14
								1,748.52	15
								1,561.86	16
								1,375.20	17
								1,188.54	18
								1,001.88	19
								815.22	20
								628.56	21
								441.90	22
								255.24	23
								68.58	24
								4,548.42	24
								4,361.76	25
								4,175.10	26
								3,988.44	27
								3,801.78	28
								3,615.12	29
								3,428.46	30
								3,241.80	31
								3,055.14	32
								2,868.48	33
								2,681.82	34
								2,495.16	35
								2,308.50	36
								2,121.84	37
								1,935.18	38
								1,748.52	39
								1,561.86	40
								1,375.20	41
								1,188.54	42
								1,001.88	43
								815.22	44
								628.56	45
								441.90	46
								255.24	47
								68.58	48
								4,548.42	48
								4,361.76	49
								4,175.10	50
								3,988.44	51
								3,801.78	52
								3,615.12	53
								3,428.46	54
								3,241.80	55
								3,055.14	56
								2,868.48	57
								2,681.82	58
								2,495.16	59
								2,308.50	60
								2,121.84	61
								1,935.18	62
								1,748.52	63
								1,561.86	64
								1,375.20	65
								1,188.54	66
								1,001.88	67
								815.22	68
								628.56	69
								441.90	70
								255.24	71
4548.42	4361.76	4175.1	3988.44	3801.78	3615.12	3428.46	3241.8	3055.14	2868.48	2681.82	2495.16	2308.5	2121.84	1935.18	1748.52	1561.86	1375.2	1188.54	1001.88	815.22	628.5599999999999	441.9	255.24	68.5799999999999	4548.42	4361.76	4175.1	3988.44	3801.78	3615.12	3428.46	3241.8	3055.14	2868.48	2681.82	2495.16	2308.5	2121.84	1935.18	1748.52	1561.86	1375.2	1188.54	1001.88	815.22	628.5599999999999	441.9	255.24	68.5799999999999	4548.42	4361.76	4175.1	3988.44	3801.78	3615.12	3428.46	3241.8	3055.14	2868.48	2681.82	2495.16	2308.5	2121.84	1935.18	1748.52	1561.86	1375.2	1188.54	1001.88	815.22	628.5599999999999	441.9	255.24	0.0	1.0	2.0	3.0	4.0	5.0	6.0	7.0	8.0	9.0	10.0	11.0	12.0	13.0	14.0	15.0	16.0	17.0	18.0	19.0	20.0	21.0	22.0	23.0	24.0	24.0	25.0	26.0	27.0	28.0	29.0	30.0	31.0	32.0	33.0	34.0	35.0	36.0	37.0	38.0	39.0	40.0	41.0	42.0	43.0	44.0	45.0	46.0	47.0	48.0	48.0	49.0	50.0	51.0	52.0	53.0	54.0	55.0	56.0	57.0	58.0	59.0	60.0	61.0	62.0	63.0	64.0	65.0	66.0	67.0	68.0	69.0	70.0	71.0