Baixe o app para aproveitar ainda mais
Leia os materiais offline, sem usar a internet. Além de vários outros recursos!
Planilha de cotação de preços por fornecedor
Esta é uma pré-visualização de arquivo. Entre para ver o arquivo original
DATA 12/30/09 Macros Desativadas PARA O CORRETO FUNCIONAMENTO DA PLANILHA É NECESSÁRIO QUE SE ATIVE AS MACROS 1. Para o perfeito funcionamento desta planilha é necessário deixar as macros em pelo menos nível Médio. 2. Para tal acesse o Menu Ferramentas, Macros, Segurança de macros. 3. Feche o arquivo e o abra novamente e habilite as macros para que a planilha possa ser utilizada. 4. Qualquer dúvida contate o desenvolver pelo email tudosobreexcel@uol.com.br COTAÇÃO DESCRIÇÃO DO PRODUTO QUANTIDADE FORNECEDOR A FORNECEDOR B FORNECEDOR C MENOR PREÇO EMPRESA COM MENOR PREÇO Valor inicial Desconto IPI Substituição tributária Frete Valor unitário Valor final Valor inicial Desconto IPI Substituição tributária Frete Valor unitário Valor final Valor inicial Desconto IPI Substituição tributária Frete Valor unitário Valor final ARROZ 19 1.10 0.10 1.00% 1.00% 29.55 30.57 580.85 8.90 1.00 2.00% 2.00% 55.80 63.90 1,214.07 7.00 0.80 2.00% 2.00% 22.10 28.46 540.75 28.46 FORNECEDOR C FEIJAO 14 2.00 0.22 2.00% 2.00% 1.00 10.00 140.00 6.30 0.55 2.00% 2.00% 55.90 18.00 252.00 5.80 0.22 2.00% 2.00% 40.22 45.94 643.11 10.00 FORNECEDOR A BATATA 12 1.24 0.10 2.00% 3.00% 32.25 12.50 150.00 1.10 2.00% 3.00% 44.80 14.00 168.00 1.22 0.08 2.00% 3.00% 55.20 1.00 12.00 1.00 FORNECEDOR C MILHO 25 2.14 1.00% 3.00% 77.58 18.00 450.00 2.00 1.00% 3.00% 28.10 10.00 250.00 2.10 0.12 1.00% 3.00% 24.10 1.00 25.00 1.00 FORNECEDOR C BANANA 30 1.25 3.00% 3.00% 89.87 1.00 30.00 1.14 0.05 3.00% 3.00% 2.90 5.00 150.00 1.30 0.07 3.00% 3.00% 12.14 13.44 403.20 1.00 FORNECEDOR A OVOS 1 0.88 1.00% 1.00% 22.00 2.00 2.00 0.17 0.04 1.00% 1.00% 10.89 3.50 3.50 0.90 0.08 1.00% 1.00% 30.99 31.83 31.83 2.00 FORNECEDOR A ABACATE 80 0.45 0.10 2.00% 1.00% 10.00 0.50 40.00 0.28 2.00% 2.00% 10.00 4.00 320.00 1.00 0.50 0.50% 0.50% 0.00 0.51 40.80 0.50 FORNECEDOR A LARANJA 10 2.45 1.00% 1.00% 0.45 3.00 30.00 2.25 2.00% 1.00% 0.66 1.00 10.00 2.10 1.00% 1.00% 1.45 14.00 140.00 1.00 FORNECEDOR B 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00 0 FORNECEDOR A MENOR PREÇO EMPRESA COM MENOR PREÇO FORNECEDOR A DESCRIÇÃO DO PRODUTO QUANTIDADE Valor inicial Desconto IPI Substituição tributária Frete Valor unitário Valor final 28.46 FORNECEDOR C ARROZ 19.00 1.10 0.10 1.00% 1.00% 29.55 30.57 580.85 10.00 FORNECEDOR A FEIJAO 14.00 2.00 0.22 2.00% 2.00% 1.00 10.00 140.00 1.00 FORNECEDOR C BATATA 12.00 1.24 0.10 2.00% 3.00% 32.25 12.50 150.00 1.00 FORNECEDOR C MILHO 25.00 2.14 0.00 1.00% 3.00% 77.58 18.00 450.00 1.00 FORNECEDOR A BANANA 30.00 1.25 0.00 3.00% 3.00% 89.87 1.00 30.00 2.00 FORNECEDOR A OVOS 1.00 0.88 0.00 1.00% 1.00% 22.00 2.00 2.00 0.50 FORNECEDOR A ABACATE 80.00 0.45 0.10 2.00% 1.00% 10.00 0.50 40.00 1.00 FORNECEDOR B LARANJA 10.00 2.45 0.00 1.00% 1.00% 0.45 3.00 30.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 FORNECEDOR A MENOR PREÇO EMPRESA DESCRIÇÃO DO PRODUTO QUANTIDADE LISTAGEM DOS PRODUTOS Valor inicial Desconto IPI Substituição tributária Frete Valor unitário Valor final 10.00 FORNECEDOR A FEIJAO 14 2.00 0.22 2.00% 2.00% 1.00 10.00 140.00 1.00 FORNECEDOR A BANANA 30 1.25 3.00% 3.00% 89.87 1.00 30.00 2.00 FORNECEDOR A OVOS 1 0.88 1.00% 1.00% 22.00 2.00 2.00 0.50 FORNECEDOR A ABACATE 80 0.45 0.10 2.00% 1.00% 10.00 0.50 40.00 CLASSIFICAR ITENS OS ITENS SELECIONADOS SERÃO MOSTRADOS ABAIXO, CLIQUE NA SETA PARA VISUALIZÁ-LOS CLASSIFICAR ITENS FORNECEDOR B MENOR PREÇO EMPRESA COM MENOR PREÇO FORNECEDOR B DESCRIÇÃO DO PRODUTO QUANTIDADE Valor inicial Desconto IPI Substituição tributária Frete Valor unitário Valor final 28.46 FORNECEDOR C ARROZ 19.00 8.90 1.00 2.00% 2.00% 55.80 63.90 1,214.07 10.00 FORNECEDOR A FEIJAO 14.00 6.30 0.55 2.00% 2.00% 55.90 18.00 252.00 1.00 FORNECEDOR C BATATA 12.00 1.10 0.00 2.00% 3.00% 44.80 14.00 168.00 1.00 FORNECEDOR C MILHO 25.00 2.00 0.00 1.00% 3.00% 28.10 10.00 250.00 1.00 FORNECEDOR A BANANA 30.00 1.14 0.05 3.00% 3.00% 2.90 5.00 150.00 2.00 FORNECEDOR A OVOS 1.00 0.17 0.04 1.00% 1.00% 10.89 3.50 3.50 0.50 FORNECEDOR A ABACATE 80.00 0.28 0.00 2.00% 2.00% 10.00 4.00 320.00 1.00 FORNECEDOR B LARANJA 10.00 2.25 0.00 2.00% 1.00% 0.66 1.00 10.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 FORNECEDOR B MENOR PREÇO EMPRESA DESCRIÇÃO DO PRODUTO QUANTIDADE LISTAGEM DOS PRODUTOS Valor inicial Desconto IPI Substituição tributária Frete Valor unitário Valor final 1.00 FORNECEDOR B LARANJA 10 2.25 2.00% 1.00% 0.66 1.00 10.00 CLASSIFICAR ITENS CLASSIFICAR ITENS OS ITENS SELECIONADOS SERÃO MOSTRADOS ABAIXO, CLIQUE NA SETA PARA VISUALIZÁ-LOS FORNECEDOR C MENOR PREÇO EMPRESA COM MENOR PREÇO FORNECEDOR C DESCRIÇÃO DO PRODUTO QUANTIDADE Valor inicial Desconto IPI Substituição tributária Frete Valor unitário Valor final 28.46 FORNECEDOR C ARROZ 19.00 7.00 0.80 2.00% 2.00% 22.10 28.46 540.75 10.00 FORNECEDOR A FEIJAO 14.00 5.80 0.22 2.00% 2.00% 40.22 45.94 643.11 1.00 FORNECEDOR C BATATA 12.00 1.22 0.08 2.00% 3.00% 55.20 1.00 12.00 1.00 FORNECEDOR C MILHO 25.00 2.10 0.12 1.00% 3.00% 24.10 1.00 25.00 1.00 FORNECEDOR A BANANA 30.00 1.30 0.07 3.00% 3.00% 12.14 13.44 403.20 2.00 FORNECEDOR A OVOS 1.00 0.90 0.08 1.00% 1.00% 30.99 31.83 31.83 0.50 FORNECEDOR A ABACATE 80.00 1.00 0.50 0.50% 0.50% 0.00 0.51 40.80 1.00 FORNECEDOR B LARANJA 10.00 2.10 0.00 1.00% 1.00% 1.45 14.00 140.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 0.00 0.00 0 0.00 0.00 0.00 0.00% 0.00% 0.00 0.00 0.00 FORNECEDOR C MENOR PREÇO EMPRESA DESCRIÇÃO DO PRODUTO QUANTIDADE LISTAGEM DOS PRODUTOS Valor inicial Desconto IPI Substituição tributária Frete Valor unitário Valor final 28.46 FORNECEDOR C ARROZ 19 7.00 0.80 2.00% 2.00% 22.10 28.46 540.75 1.00 FORNECEDOR C BATATA 12 1.22 0.08 2.00% 3.00% 55.20 1.00 12.00 1.00 FORNECEDOR C MILHO 25 2.10 0.12 1.00% 3.00% 24.10 1.00 25.00 CLASSIFICAR ITENS CLASSIFICAR ITENS OS ITENS SELECIONADOS SERÃO MOSTRADOS ABAIXO, CLIQUE NA SETA PARA VISUALIZÁ-LOS
Compartilhar
Materiais relacionados
Perguntas relacionadas
Compartilhar