Kolumn

01 / 20 · Purchasing and stock

Supplier comparison

Pick a supplier on facts, not gut feeling.

SEK 129

Incl. 25% Swedish VAT. Buyers outside the EU and EU businesses with a valid VAT number pay 20% less.

Also part of the bundle with all 20 templates for SEK 499. All 20 templates

Middle Earth Consulting AB contributes 1% of your purchase to removing carbon dioxide from the atmosphere.

What it does

Compare up to 15 suppliers on price, MOQ, lead time, sample quality, communication and certifications. You decide how much each criterion weighs, and the template calculates a total score and a ranking.

What you get

Sheets
Comparison
Each file also has an instructions sheet and a lists sheet.
Formulas
121
Files
2 × .xlsx: English and Swedish
Works in
Excel (Windows, Mac, web), Google Sheets, LibreOffice
Macros
None
Licence
One licence per business or household, unlimited internal users

Screenshots

English version with example data
English version with example data
Swedish version with example data
Swedish version with example data

How to use it

  1. Go to the Comparison sheet and set the weights in row 5. They should add up to 100%.
  2. Enter one row per supplier: unit price in the same currency for all, MOQ and lead time in days.
  3. Rate the sample and the communication 1–5 once you have samples and replies.
  4. The scores on the right are automatic: the lowest price, MOQ and lead time get 5 points, the others get points in proportion.
  5. Rank 1 is the best total score. Change the weights and watch the order change.