--- title: Know which supplier has the best price on each item. description: Your AI reads the suppliers' quotes as PDF or spreadsheet and saves the quote comparison with the best price per item, with the source of every number. language: en-US canonical: https://www.siglata.com/en-US/trabalhos/cotacao-de-fornecedores --- # Know which supplier has the best price on each item. Canonical: https://www.siglata.com/en-US/trabalhos/cotacao-de-fornecedores Your AI reads the suppliers' quotes, as PDF or spreadsheet, and saves the quote comparison with the best price for each item, with the source of every number. ## Three quotes, three formats One supplier sends a PDF priced per unit, another sends a spreadsheet priced per case, and the third leaves an item out. Someone types it all into a spreadsheet, converts the cases and looks for the lowest price row by row. ## One sentence, the best price per item You ask to compare the week's quotes. Your AI reads the three quotes, puts every price in the same unit and saves the best one for each item as a new version of the quote comparison, with the previous one kept. ## Every number with its source Tap a best price to see each supplier's price, the case-to-unit conversion and the row of every number in the quote. ## The quote rule is written down What goes into the comparison, how a case becomes units and what to do when a supplier leaves an item out live in a company skill. Each person works with their own access, and every change stays in the history, with the previous version kept. 1. Three quotes, three formats: One supplier sends a PDF priced per unit, another sends a spreadsheet priced per case, and the third leaves an item out. Someone types it all into a spreadsheet, converts the cases and looks for the lowest price row by row. 2. Know which supplier has the best price on each item.: Your AI reads the suppliers' quotes, as PDF or spreadsheet, and saves the quote comparison with the best price for each item, with the source of every number. 3. One sentence, the best price per item: You ask to compare the week's quotes. Your AI reads the three quotes, puts every price in the same unit and saves the best one for each item as a new version of the quote comparison, with the previous one kept. 4. Every number with its source: Tap a best price to see each supplier's price, the case-to-unit conversion and the row of every number in the quote. | Item | Qty | Distribuidora Sul | Rede Norte | Atacado Leste | Best price | Supplier | Total | Savings | | --- | --- | --- | --- | --- | --- | --- | --- | --- | | Açúcar 1 kg | 160 | 4.20 | 4.35 | 4.10 | 4.10 | Atacado Leste | 656.00 | 16.00 | | Leite 1 L | 144 | 5.10 | 4.90 | 5.05 | 4.90 | Rede Norte | 705.60 | 21.60 | | Café 500 g | 112 | 18.90 | 18.40 | 19.20 | 18.40 | Rede Norte | 2,060.80 | 56.00 | | Azeite 500 ml | 80 | 27.50 | 26.90 | 28.00 | 26.90 | Rede Norte | 2,152.00 | 48.00 | | Detergente 500 ml | 48 | 2.30 | 2.45 | 2.20 | 2.20 | Atacado Leste | 105.60 | 4.80 | | Arroz 5 kg | 60 | 26.90 | 27.40 | — | 26.90 | Distribuidora Sul | 1,614.00 | 30.00 | | Feijão 1 kg | 100 | 8.40 | 8.10 | 8.30 | 8.10 | Rede Norte | 810.00 | 20.00 | | Óleo 900 ml | 120 | 7.80 | 7.95 | 7.90 | 7.80 | Distribuidora Sul | 936.00 | 12.00 | | Molho 340 g | 96 | 3.10 | 3.25 | 2.95 | 2.95 | Atacado Leste | 283.20 | 14.40 | | Biscoito 400 g | 150 | 4.60 | 4.50 | 4.75 | 4.50 | Rede Norte | 675.00 | 15.00 | | Total | — | — | — | — | — | — | 9,998.20 | 237.80 | ### Leite 1 L · Best price R$4.90 · Rede Norte Distribuidora Sul: R$5.10 per unit. Rede Norte: R$58.80 per case of 12. 58.80 ÷ 12 = R$4.90 per unit. Atacado Leste: R$5.05 per unit. Lowest price: R$4.90, from Rede Norte. Total: 144 × 4.90 = R$705.60. Savings against the second-lowest: (5.05 − 4.90) × 144 = R$21.60. Mapa_de_cotacao.xlsx v1: Row 3 · Item: Leite 1 L · Qty: 144 Cotacao_Distribuidora_Sul.pdf v1: page 1, item 2 · Leite 1 L · R$5.10 per unit Cotacao_Rede_Norte.xlsx v1: Row 5 · Leite integral 1 L · Pack: cx c/ 12 · Price: R$58.80 Cotacao_Atacado_Leste.pdf v1: page 1, item 2 · Leite 1 L · R$5.05 per unit Cotacao_de_compras : (company skill) · item 2: a price per case becomes a price per unit, divided by the units in the case | | | | In its quote, Rede Norte prices by the case and looks the most expensive. Per unit, it is the cheapest of the three, R$0.15 below Atacado Leste. Mapa_de_cotacao.xlsx v1 to v2 Item · Best price · Second-lowest · Total · Savings | Item | Best price | Second-lowest | Total | Savings | | --- | --- | --- | --- | --- | | Açúcar 1 kg | 4.10 (Leste) | 4.20 (Sul) | 160 × 4.10 = 656.00 | 0.10 × 160 = 16.00 | | Leite 1 L | 58.80 ÷ 12 = 4.90 (Norte) | 5.05 (Leste) | 144 × 4.90 = 705.60 | 0.15 × 144 = 21.60 | | Café 500 g | 18.40 (Norte) | 18.90 (Sul) | 112 × 18.40 = 2,060.80 | 0.50 × 112 = 56.00 | | Azeite 500 ml | 26.90 (Norte) | 27.50 (Sul) | 80 × 26.90 = 2,152.00 | 0.60 × 80 = 48.00 | | Detergente 500 ml | 2.20 (Leste) | 2.30 (Sul) | 48 × 2.20 = 105.60 | 0.10 × 48 = 4.80 | | Arroz 5 kg | 26.90 (Sul) | 27.40 (Norte); no Leste price | 60 × 26.90 = 1,614.00 | 0.50 × 60 = 30.00 | | Feijão 1 kg | 8.10 (Norte) | 8.30 (Leste) | 100 × 8.10 = 810.00 | 0.20 × 100 = 20.00 | | Óleo 900 ml | 7.80 (Sul) | 7.90 (Leste) | 120 × 7.80 = 936.00 | 0.10 × 120 = 12.00 | | Molho 340 g | 2.95 (Leste) | 3.10 (Sul) | 96 × 2.95 = 283.20 | 0.15 × 96 = 14.40 | | Biscoito 400 g | 4.50 (Norte) | 4.60 (Sul) | 150 × 4.50 = 675.00 | 0.10 × 150 = 15.00 | Supplier · Items · Total | Supplier | Items | Total | | --- | --- | --- | | Rede Norte | Leite, Café, Azeite, Feijão, Biscoito (5) | 705.60 + 2,060.80 + 2,152.00 + 810.00 + 675.00 = 6,403.40 | | Atacado Leste | Açúcar, Detergente, Molho (3) | 656.00 + 105.60 + 283.20 = 1,044.80 | | Distribuidora Sul | Arroz, Óleo (2) | 1,614.00 + 936.00 = 2,550.00 | | Total | 10 | 6,403.40 + 1,044.80 + 2,550.00 = 9,998.20 | [Download the example (.xlsx)](https://www.siglata.com/en-US/trabalhos/cotacao-de-fornecedores/planilha.xlsx) Illustrative data. ## Frequently asked questions ### Which ChatGPT does it work in? ChatGPT Business and Enterprise: an admin enables Siglata once for the team. On Pro, Siglata is read-only, in developer mode. On Plus and Free, it doesn't work in ChatGPT on the web. In Codex, each person connects it, on every plan that includes Codex. ### Does it work with my ERP? Two ways: with the ERP's exports, as spreadsheets or CSV, and in the ERP's own pages, like Bling: your AI signs in to the portal with the login you or the company connected, reads lists and tables, clicks, fills in and posts, without seeing the password. The suppliers' quotes come in as files, PDF or spreadsheet. ### How do I compare price quotes in Excel? One row per item, with the quantity, and one price column per supplier, all in the same unit. The best price is =MIN(C2:E2), and the item's total is the quantity times that price. Your AI does the same math from the suppliers' PDFs and spreadsheets, converts cases into units and saves the quote comparison. ### Can ChatGPT create spreadsheets? Yes. With Siglata, your AI reads the suppliers' quotes and fills in the quote comparison in the company's spreadsheet, with the source of every price. Each round of quotes becomes a new version, and the earlier ones stay saved. ## Want to see it with your company's quotes? We'll show it with your suppliers' quotes, as PDF or spreadsheet, in a WhatsApp conversation. [Let's talk](https://wa.me/5516991184410?text=Hi!%20I'd%20like%20to%20see%20supplier%20quotes%20with%20Siglata.)