Exercício curva ABC 2

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

Plan1
	Item	Consumo 
(Unidades por mês)	Custo 
(R$ por unidade)
	1	* 450	R$2.35
	2	* 23,590	R$0.45
	3	* 12,025	R$2.05
	4	* 670	R$3.60
	5	* 25	R$150.00
	6	* 6,540	R$0.80
	7	* 2,460	R$12.00
	8	* 3,480	R$2.60
	9	* 1,250	R$0.08
	10	* 4,020	R$0.50
	11	* 1,890	R$2.75
	12	* 680	R$3.90
	13	* 345	R$6.80
	14	* 9,870	R$0.75
	15	* 5,680	R$0.35
Plan2
	item	preço	quantidade negociada
	1	R$746.66	2238
	2	R$413.63	1240
	3	R$398.40	1195
	4	R$571.38	1714
	5	R$455.88	1367
	6	R$407.91	1223
	7	R$194.43	583
	8	R$325.92	977
	9	R$473.10	1419
	10	R$546.00	1638
	11	R$597.60	1792
	12	R$3,035.03	9105
	13	R$3,680.60	1140
	14	R$427.99	1283
	15	R$951.44	2854
	16	R$662.61	1987
	17	R$135.81	407
	18	R$210.80	632
	19	R$1,462.52	4387
	20	R$831.80	2485
	21	R$50.40	151
	22	R$155.48	466
	23	R$195.18	582
	24	R$301.50	902
	25	R$191.88	575
	26	R$51.80	155
	27	R$965.00	2895
	28	R$318.92	956
	29	R$124.80	347
	30	R$104.30	312
Plan3
	item	valor negociado
	1	R$928.50
	2	R$143.40
	3	R$1,180.02
	4	R$602.10
	5	R$1,524.30
	6	R$8,235.54
	7	R$17,569.01
	8	R$74.70
	9	R$522.90
	10	R$1,517.31
	11	R$534.30
	12	R$904.20
	13	R$2,630.40
	14	R$493.20
	15	R$4,603.20
	16	R$986.40
	17	R$5,298.60
	18	R$9,839.98
	19	R$1,434.00
	20	R$1,199.25
	21	R$239.85
	22	R$286.80
	23	R$1,417.98
	24	R$2,007.60
	25	R$2,572.83
	26	R$3,297.63
	27	R$19,262.25
	28	R$16,843.19
	29	R$6,201.18
	30	R$395.82
	31	R$2,440.89
	32	R$4,288.05
	33	R$395.82
	34	R$791.64
	35	R$591.75
	36	R$329.85
	37	R$263.88
	38	R$527.76
	39	R$1,847.16
	40	R$3,760.29
	41	R$1,781.19
	42	R$1,055.52
	43	R$131.94
	44	R$1,451.34
	45	R$1,517.31
	46	R$527.76
	47	R$10,761.49
	48	R$386.58
	49	R$1,451.34
	50	R$2,374.17
Plan4
	itens	valores negociados
	1	R$127.65
	2	R$419.47
	3	R$394.57
	4	R$1,725.64
	5	R$473.84
	6	R$124.20
	7	R$40.05
	8	R$227.48
	9	R$213.60
	10	R$161.85
	11	R$118.00
	12	R$938.18
	13	R$89.17
	14	R$29.96
	15	R$914.65
	16	R$97.06
	17	R$120.67
	18	R$163.13
	19	R$511.13
	20	R$19.35
	21	R$695.92
	22	R$756.00
	23	R$694.13
	24	R$742.42
	25	R$367.58
	26	R$428.81
	27	R$1,851.34
	28	R$148.13
	29	R$346.34
	30	R$1,407.79
	31	R$560.75
	32	R$213.57
	33	R$293.89
	34	R$1,048.65
	35	R$597.67
	36	R$1,258.59
	37	R$362.83
	38	R$148.44
	39	R$291.66
	40	R$156.33
	41	R$218.93
	42	R$138.70
	43	R$114.68
	44	R$267.59
	45	R$63.71
	46	R$114.68
	47	R$305.82
	48	R$165.65
	49	R$76.45
	50	R$331.31
	51	R$203.88
	52	R$50.97
	53	R$178.40
	54	R$191.14
	55	R$1,382.03
	56	R$120.23
	57	R$95.16
	58	R$115.50
	59	R$87.45
	60	R$116.10
	61	R$114.07
	62	R$887.44
	63	R$150.00
	64	R$3,650.07
	65	R$395.75
	66	R$419.74
	67	R$359.77
	68	R$1,607.18
	69	R$887.44
	70	R$395.75
	71	R$305.10
	72	R$616.28
	73	R$2,759.68
	74	R$354.83
	75	R$336.15
	76	R$261.45
	77	R$949.81
	78	R$4,118.73
	79	R$477.00
	80	R$672.30
	81	R$314.86
	82	R$1,994.00
	83	R$426.91
	84	R$915.07
	85	R$224.10
	86	R$93.38
	87	R$168.07
	88	R$298.80
	89	R$828.07
	90	R$1,630.08
	91	R$176.93
	92	R$2,622.68
	93	R$1,372.48
	94	R$1,523.23
	95	R$2,917.99
	96	R$285.08
	97	R$2,893.39
	98	R$443.78
	99	R$2,635.98
	100	R$3,415.74