Electronic Component Distributor Quote Comparison Worksheet
Quotes arrive in different formats, at different quantity breaks and with different lead times. This worksheet puts them in one grid so the real price spread is visible before you place an order.
| Manufacturer part number | Qty | Distributor A price | Distributor B price | Distributor C price | Lowest price | Spread high vs low | Lead time A (wks) | Lead time B (wks) | Lead time C (wks) | Spend at lowest price | Spend at highest price | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
$3 | 12.4% | $14,900 | $16,750 | |||||||||
$1 | 7.1% | $8,400 | $9,000 | |||||||||
$3 | 9.2% | $9,750 | $10,650 | |||||||||
$0 | 12.1% | $2,900 | $3,250 |
Enter the price at the quantity break that matches the quantity you intend to buy. Lead time 0 means stock on hand. Lowest price is not automatically the best choice: consider lead time, minimum order, cancellation terms and channel authorization before awarding.
Compare quotes from ERP data
Optional: we can show how purchase history and open quotes can feed a comparison view.
Optional. The tool and every export work without this. No spam.
How to use it
Enter each part once with the quantity you intend to buy, then the unit price each distributor quoted at that quantity. Enter lead time in weeks, using zero for stock on hand. The sheet picks the lowest price, shows the spread between highest and lowest and totals the spend at each. Use the summary to see the maximum saving from shopping the order around, which is a number you can show a manager when asking for time to quote.
- Compare prices at the same quantity break only
- Check the standard pack, since buying to pack may change the price
- Leave a price blank only if you also remove the column from min()
- Keep the quote reference in your file for audit
Reading the spread
A spread under a few percent usually means the market is stable and you should award on lead time and service. A large spread signals that one supplier holds cheap stock, or that a quote is from a less reliable channel. Be careful with a very low outlier on a scarce part: check that the supplier is authorized, and pair this sheet with a counterfeit risk review before buying.
Beyond unit price
Landed cost includes freight, duties, handling charges and any minimum order fee. Payment terms and cancellation rights also carry cost. If one supplier ships complete from stock and another needs a factory order with a cancellation penalty, the safer award may carry a higher unit price. Record the reasoning with the award so future buyers understand it.
Common mistakes
Mistakes include mixing currencies, comparing a reel price with a cut tape price, not noting tariffs or freight, and awarding to the lowest price without checking the date code and traceability. When two suppliers tie on price, split the order if your volume allows, to keep both relationships active.
Frequently Asked Questions
How many distributors should I compare?
Three is practical for most orders. More adds effort without much new information unless the part is scarce. For high-spend lines, ask the manufacturer for a direct quote as well.
Why is my total at lowest prices not achievable?
Because splitting every line across suppliers adds freight and handling. Treat the total as a ceiling on savings, then group lines by supplier and recompute with shipping before awarding.
Should I compare cut tape and reel prices?
Compare like with like. Reel prices are usually lower per piece but require buying the full reel. Use the reel and MOQ calculator on this site to see the cost of any excess.
Can I add a fourth supplier?
After exporting to Excel you can add columns. In the browser sheet, use the notes column in your file to capture a fourth quote or replace the highest priced supplier's column.
Netray can help pull quotes and purchase history from your ERP into one comparison view, leaving the award decision with your buyer.
Related Tools
Electronic Component RFQ Request Template
A fill-in request for quotation to send to franchised distributors and manufacturers, with traceability and compliance requirements built in.
Supply Chain & InventorySMT Reel and MOQ Buy Quantity Calculator
See how minimum order quantity and reel size change what you actually buy, how much excess you hold and what it costs to carry.
Electronics ManufacturingIndependent Distributor Purchase Approval Form Template
Document why a shortage buy from a broker or independent distributor is needed, the risk controls and the test plan, with signatures.
Electronics ManufacturingElectronics BOM Cost Calculator
Estimate loaded BOM cost per board and annual material spend, including volume pricing tiers, procurement overhead, and attrition.
More Supply Chain & Inventory tools
See all- PCBA RFQ Request for Quote Template
- Component Lead Time Risk Worksheet
- Approved Vendor List (AVL) Template
- Broker vs Franchise Component Buy Cost Calculator
- Reel MOQ Overbuy and Carrying Cost Calculator
- Component Shortage Line-Down and Expedite Cost Calculator
- Electronic Component Sourcing Resilience Assessment
- Oracle Fusion Inventory Turns and Carrying Cost Calculator
- Distribution ERP Fill Rate Calculator
Keep exploring
Free tools
- Supplier RFQ Quote Comparison WorksheetCompare supplier quotes on landed cost: unit price, freight, duty, MOQ and lead time per supplier, with extended cost and price spread calculated.
- Electronic Component RFQ Request TemplateA fill-in request for quotation to send to franchised distributors and manufacturers, with traceability and compliance requirements built in.
- Supplier Total Cost of Ownership Comparison WorksheetCompare suppliers on landed, quality and inventory carrying cost per unit to find the lowest total cost, not just the lowest price.
Guides
- Distribution ERP Comparison: Which Platform Fits?Compare distribution ERP platforms for wholesale and distribution. Infor M3, Epicor Prophet 21, SAP Business One, and NetSuite evaluated for distributors.
- How to Quote PCB Assembly From a Customer BOMStep by step PCB assembly quoting from a customer BOM: part matching, price breaks, lead time risk, overage and attrition, and quote validity for EMS shops.
- Counterfeit Electronic Parts Avoidance for EMS CompaniesWhat EMS shops must do to avoid counterfeit electronic parts: DFARS 252.246-7007 and 7008, AS5553 and AS6081, approved sources, inspection, and records.
AI on your ERP
- AI for Epicor Eclipse, Without Sending Distributor Data Off-SiteAdd private, on-prem AI to Epicor Eclipse for rebate reconciliation, counter sales lookups, and EDI exception triage without sending distributor data to the cloud.
- Infor LN AI for High-Tech Electronics: BOMs, Shortages and TraceabilityPrivate AI on Infor LN for electronics makers: BOM and ECO impact, AVL shortages, obsolescence, RoHS and REACH data, and serial traceability, run on-prem.
Software
- SiliconExpertSiliconExpert is an electronic component intelligence service covering lifecycle, compliance and cross-references. See modules, integrations and alternatives.
- OctopartOctopart is a search engine for electronic components with distributor pricing, stock and datasheets. See features, API options, limits and alternatives.