513_aula_4_exemplos

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

procv_proch
	
		Os valores abaixo referem-se aos custos de transporte e seguro de mercadorias de acordo com a quantidade solicitada.
	
	
	
	
		Tamanho lote	$ transporte	$ seguro
		50	107.000	21.40
		100	150.000	30.00
		150	184.000	36.80
		200	213.000	42.60		a) custo de transporte de um lote de 350 unidades					(comando procv)
		250	238.000	47.60		$281.00
		300	260.000	52.00
		350	281.000	56.20		b) custo de seguro de um lote de 1000 unidades					(idem anterior)
		400	300.000	60.00		$95.00
		450	319.000	63.80
		500	336.000	67.20		c) custo de transporte de um lote de 320 unidades
		550	352.000	70.40		$260.00
		600	368.000	73.60
		650	383.000	76.60		d) custo de seguro de um lote de 1020 unidades
		700	397.000	79.40		$95.00
		750	411.000	82.20
		800	425.000	85.00		e) posição da tabela em que custo de transporte =300
		850	438.000	87.60
		900	450.000	90.00
		950	463.000	92.60		f) posição da tabela onde se verifica custo máximo de transporte
		1000	475.000	95.00
		1050	487.000	97.40
		1100	498.000	99.60		g) comando índice
		1150	509.000	101.80
		1200	520.000	104.00
		1250	531.000	106.20
ordem
	Item	Unidades	Valor
		Compradas	Unitário
		Média Anual
	Conversor analógico/digital	2000	$350.00
	Modem externo 36K	1000	$150.00
	Drive de disquete 3.5"	10000	$300.00		a) dispor unidades compradas em ordem crescente
	Conversor VGA/NTSC	100	$525.00
	Cartão Ethernet	10000	$120.00
	Fonte RS232	1100	$35.00		b) dispor unidades compradas em ordem decrescente e então valor unitário em ordem crescente
	Programador EPROM	500	$160.00
	Cartão Color VGA	80000	$120.00
	Winchester XT HD	20000	$40.00		c) Fazer uma classificação ABC dos produtos de acordo com seu Total (unidades compradas x valor unitário)
	Osciloscópio T8	1000	$1,500.00
localizar e substituir
	Data	Medicamento	Cidade	Vendedor	Quantidade	Unitário	Total
	1/18/01	Cloranfenicol	Rio de Janeiro	Sandra	102	R$150.00	R$15,300.00
	1/23/01	Hidantal	Campinas	Marcos	116	R$110.00	R$12,760.00
	1/30/01	Vancomicina	Curitiba	João	111	R$1,214.00	R$134,754.00
	2/7/01	Cloranfenicol	Campinas	Marina	153	R$150.00	R$22,950.00
	2/11/01	Cloranfenicol	Curitiba	Sandra	78	R$150.00	R$11,700.00			a) localizar vendas feitas em Campinas (uma a uma)
	2/15/01	Omeprazol	Campinas	Marcos	81	R$14.00	R$1,134.00
	2/20/01	Cloranfenicol	Brasilia	João	106	R$150.00	R$15,900.00			b) substituir todas as ocorrências de Sandra por Pedro
	3/7/01	Hidantal	Campinas	Marina	118	R$110.00	R$12,980.00
	3/11/01	Omeprazol	Rio de Janeiro	Sandra	76	R$14.00	R$1,064.00			c) substituir todas as ocorrências de Campinas por POA
	3/16/01	Cloranfenicol	Salvador	Marcos	82	R$150.00	R$12,300.00
	3/19/01	Dipirona	Ribeirão Preto	João	110	R$65.00	R$7,150.00
	3/20/01	Fenobarbital	Franca	Marina	110	R$86.00	R$9,460.00
	3/23/01	Cloranfenicol	Santos	Sandra	86	R$150.00	R$12,900.00
	3/25/01	Dipirona	Barretos	Marcos	95	R$65.00	R$6,175.00
	3/28/01	Hidantal	Brasilia	João	120	R$110.00	R$13,200.00
	3/29/01	Omeprazol	Campinas	Marina	71	R$14.00	R$994.00
	3/30/01	Dipirona	Brasilia	Sandra	119	R$65.00	R$7,735.00
	4/2/01	Cloranfenicol	Salvador	Marcos	86	R$150.00	R$12,900.00
	4/4/01	Vancomicina	Salvador	João	114	R$1,214.00	R$138,396.00
	4/5/01	Vancomicina	Salvador	Marina	123	R$1,214.00	R$149,322.00
	4/7/01	Dipirona	Rio de Janeiro	Sandra	113	R$65.00	R$7,345.00
	4/7/01	Fenobarbital	Rio de Janeiro	Marcos	106	R$86.00	R$9,116.00
	4/11/01	Vancomicina	Curitiba	João	117	R$1,214.00	R$142,038.00
	4/18/01	Dipirona	Curitiba	Marina	107	R$65.00	R$6,955.00
	4/22/01	Fenobarbital	Franca	Sandra	96	R$86.00	R$8,256.00
	4/27/01	Dipirona	Ribeirão Preto	Marcos	92	R$65.00	R$5,980.00
	5/2/01	Dipirona	Santos	João	104	R$65.00	R$6,760.00
	5/7/01	Fenobarbital	Rio de Janeiro	Marina	98	R$86.00	R$8,428.00
	5/11/01	Cloranfenicol	Barretos	Sandra	90	R$150.00	R$13,500.00
	5/15/01	Dipirona	Campinas	Marcos	118	R$65.00	R$7,670.00
	5/18/01	Dipirona	Santos	João	116	R$65.00	R$7,540.00
	5/20/01	Dipirona	Barretos	Marina	114	R$65.00	R$7,410.00
	5/20/01	Dipirona	Curitiba	Sandra	94	R$65.00	R$6,110.00
	5/21/01	Hidantal	Franca	Marcos	122	R$110.00	R$13,420.00
	5/23/01	Cloranfenicol	Brasilia	João	98	R$150.00	R$14,700.00
	5/26/01	Dipirona	Campinas	Marina	110	R$65.00	R$7,150.00
	5/30/01	Vancomicina	Curitiba	Sandra	120	R$1,214.00	R$145,680.00
	6/1/01	Dipirona	Franca	Marcos	101	R$65.00	R$6,565.00
	6/8/01	Dipirona	Salvador	João	98	R$65.00	R$6,370.00
	6/11/01	Dipirona	Curitiba	Marina	122	R$65.00	R$7,930.00
	6/15/01	Fenobarbital	Santos	Sandra	108	R$86.00	R$9,288.00
	6/23/01	Dipirona	Ribeirão Preto	Marcos	126	R$65.00	R$8,190.00
	6/24/01	Fenobarbital	Ribeirão Preto	João	114	R$86.00	R$9,804.00
	7/2/01	Fenobarbital	Curitiba	Marina	112	R$86.00	R$9,632.00
	7/10/01	Dipirona	Salvador	João	130	R$65.00	R$8,450.00
	7/13/01	Omeprazol	Curitiba	Marina	66	R$14.00	R$924.00
	7/19/01	Hidantal	Curitiba	Sandra	111	R$110.00	R$12,210.00
	7/21/01	Hidantal	Salvador	Marcos	106	R$110.00	R$11,660.00
	7/23/01	Omeprazol	Campinas	João	69	R$14.00	R$966.00
	7/26/01	Hidantal	Salvador	Marina	101	R$110.00	R$11,110.00
	7/28/01	Vancomicina	Ribeirão Preto	Sandra	118	R$1,214.00	R$143,252.00
	7/29/01	Hidantal	Barretos	Marcos	124	R$110.00	R$13,640.00
	8/1/01	Hidantal	Brasilia	João	86	R$110.00	R$9,460.00
	8/4/01	Dipirona	Brasilia	Marina	134	R$65.00	R$8,710.00
	8/10/01	Hidantal	Barretos	Sandra	91	R$110.00	R$10,010.00
	8/11/01	Fenobarbital	Curitiba	Marcos	100	R$86.00	R$8,600.00
	8/13/01	Omeprazol	Santos	João	90	R$14.00	R$1,260.00
	8/20/01	Cloranfenicol	Santos	Marina	124	R$150.00	R$18,600.00
	8/22/01	Omeprazol	Ribeirão Preto	João	72	R$14.00	R$1,008.00
	8/28/01	Hidantal	Franca	Marina	96	R$110.00	R$10,560.00
	8/30/01	Hidantal	Ribeirão Preto	Sandra	116	R$110.00	R$12,760.00
	9/2/01	Fenobarbital	Santos	Marcos	102	R$86.00	R$8,772.00
	9/6/01	Dipirona	Rio de Janeiro	João	131	R$65.00	R$8,515.00
	9/8/01	Omeprazol	Ribeirão Preto	Marina	105	R$14.00	R$1,470.00
	9/10/01	Omeprazol	Franca	Sandra	99	R$14.00	R$1,386.00
	9/11/01	Dipirona	Franca	Marcos	128	R$65.00	R$8,320.00
	9/14/01	Omeprazol	Santos	João	87	R$14.00	R$1,218.00
	9/19/01	Omeprazol	Ribeirão Preto	Marina	102	R$14.00	R$1,428.00
	9/23/01	Omeprazol	Brasilia	Sandra	93	R$14.00	R$1,302.00
	9/27/01	Omeprazol	Rio de Janeiro	Marcos	96	R$14.00	R$1,344.00
	9/30/01	Hidantal	Ribeirão Preto	João	126	R$110.00	R$13,860.00
	10/2/01	Omeprazol	Campinas	Marina	108	R$14.00	R$1,512.00
	10/7/01	Fenobarbital	Ribeirão Preto	João	104	R$86.00	R$8,944.00
	10/9/01	Omeprazol	Ribeirão Preto	Marina	75	R$14.00	R$1,050.00
	10/10/01	Omeprazol	Brasilia	Sandra	78	R$14.00	R$1,092.00
	10/11/01	Vancomicina	Barretos	Marcos	113	R$1,214.00	R$137,182.00
	10/20/01	Omeprazol	Curitiba	João	84	R$14.00	R$1,176.00
	10/22/01	Vancomicina	Ribeirão Preto	Marina	83	R$1,214.00	R$100,762.00
	10/30/01	Vancomicina	Brasilia	Sandra	92	R$1,214.00	R$111,688.00
	11/2/01	Dipirona	Curitiba	Marcos	125	R$65.00	R$8,125.00
	11/4/01	Dipirona	Ribeirão Preto	João	122	R$65.00	R$7,930.00
	11/11/01	Omeprazol	Franca	Marina	81	R$14.00	R$1,134.00
	11/13/01	Vancomicina	Brasilia	Sandra	108	R$1,214.00	R$131,112.00
	11/17/01	Vancomicina	Ribeirão Preto	Marcos	107	R$1,214.00	R$129,898.00
	11/18/01	Vancomicina	Campinas	João	103	R$1,214.00	R$125,042.00
	11/19/01	Vancomicina	Salvador	Marina	95	R$1,214.00	R$115,330.00
	11/20/01	Vancomicina	Ribeirão Preto	João	86	R$1,214.00	R$104,404.00
	11/24/01	Hidantal	Barretos	Marina	121	R$110.00	R$13,310.00
	12/5/01	Vancomicina	Campinas	Sandra	98	R$1,214.00	R$118,972.00
	12/6/01	Vancomicina	Ribeirão Preto	Marcos	98	R$1,214.00	R$118,972.00
	12/10/01	Vancomicina	Santos	João	93	R$1,214.00	R$112,902.00
	12/11/01	Vancomicina	Ribeirão Preto	Marina	101	R$1,214.00	R$122,614.00
	12/14/01	Cloranfenicol	Rio de Janeiro	Sandra	102	R$150.00	R$15,300.00
	12/14/01	Cloranfenicol	Campinas	Sandra	90	R$150.00	R$13,500.00
	12/16/01	Cloranfenicol	Rio de Janeiro	Marcos	98	R$150.00	R$14,700.00
	12/19/01	Hidantal	Campinas	Marcos	116	R$110.00	R$12,760.00
	12/19/01	Vancomicina	Salvador	João	110	R$1,214.00	R$133,540.00
	12/26/01	Vancomicina
Curitiba	João	111	R$1,214.00	R$134,754.00
	12/28/01	Vancomicina	Santos	Marina	88	R$1,214.00	R$106,832.00
	12/30/01	Vancomicina	Barretos	Sandra	89	R$1,214.00	R$108,046.00
	1/3/02	Cloranfenicol	Campinas	Marina	153	R$150.00	R$22,950.00
	1/6/02	Vancomicina	Ribeirão Preto	Marcos	104	R$1,214.00	R$126,256.00
	1/7/02	Cloranfenicol	Curitiba	Sandra	78	R$150.00	R$11,700.00
	1/7/02	Cloranfenicol	Curitiba	João	94	R$150.00	R$14,100.00
	1/11/02	Omeprazol	Campinas	Marcos	81	R$14.00	R$1,134.00
	1/16/02	Cloranfenicol	Brasilia	João	106	R$150.00	R$15,900.00
	1/31/02	Hidantal	Campinas	Marina	118	R$110.00	R$12,980.00
	2/4/02	Omeprazol	Rio de Janeiro	Sandra	76	R$14.00	R$1,064.00
	2/9/02	Cloranfenicol	Salvador	Marcos	82	R$150.00	R$12,300.00
	2/12/02	Dipirona	Ribeirão Preto	João	110	R$65.00	R$7,150.00
	2/13/02	Fenobarbital	Franca	Marina	110	R$86.00	R$9,460.00
	2/16/02	Cloranfenicol	Santos	Sandra	86	R$150.00	R$12,900.00
	2/18/02	Dipirona	Barretos	Marcos	95	R$65.00	R$6,175.00
	2/21/02	Hidantal	Brasilia	João	120	R$110.00	R$13,200.00
	2/22/02	Omeprazol	Campinas	Marina	71	R$14.00	R$994.00
	2/23/02	Dipirona	Brasilia	Sandra	119	R$65.00	R$7,735.00
	2/26/02	Cloranfenicol	Salvador	Marcos	86	R$150.00	R$12,900.00
	2/28/02	Vancomicina	Salvador	João	114	R$1,214.00	R$138,396.00
	3/1/02	Vancomicina	Salvador	Marina	123	R$1,214.00	R$149,322.00