exercicio parcial

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

Planilha1
	código	consumo médio	preço unitário	preço x de consumo	%	valor acumulado 	%	curva ABC	CURVA ABC
	20170	12500	43.00	R$537,500.00	34.5%	R$537,500.00	34.5%	A	A	80%
	20120	4287	110.00	R$471,570.00	30.3%	R$1,009,070.00	64.8%	A	B	95%
	20260	250	880.00	R$220,000.00	14.1%	R$1,229,070.00	79.0%	A	C	100%
	20270	550	104.00	R$57,200.00	3.7%	R$1,286,270.00	82.6%	B
	20130	550	104.00	R$57,200.00	3.7%	R$1,343,470.00	86.3%	B
	20230	250	213.00	R$53,250.00	3.4%	R$1,396,720.00	89.7%	B
	20190	750	57.00	R$42,750.00	2.7%	R$1,439,470.00	92.5%	B
	20290	1250	21.00	R$26,250.00	1.7%	R$1,465,720.00	94.2%	B
	20250	1250	21.00	R$26,250.00	1.7%	R$1,491,970.00	95.9%	C
	20180	95	210.00	R$19,950.00	1.3%	R$1,511,920.00	97.1%	C
	20100	625	18.00	R$11,250.00	0.7%	R$1,523,170.00	97.9%	C
	20220	125	74.00	R$9,250.00	0.6%	R$1,532,420.00	98.5%	C
	20280	30	138.00	R$4,140.00	0.3%	R$1,536,560.00	98.7%	C
	20210	500	8.00	R$4,000.00	0.3%	R$1,540,560.00	99.0%	C
	20110	125	28.00	R$3,500.00	0.2%	R$1,544,060.00	99.2%	C
	20140	187	16.00	R$2,992.00	0.2%	R$1,547,052.00	99.4%	C
	20200	187	16.00	R$2,992.00	0.2%	R$1,550,044.00	99.6%	C
	20150	37	80.00	R$2,960.00	0.2%	R$1,553,004.00	99.8%	C
	20240	63	32.00	R$2,016.00	0.1%	R$1,555,020.00	99.9%	C
	20160	187	8.00	R$1,496.00	0.1%	R$1,556,516.00	100.0%	C
	valor total 	R$1,556,516.00