ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Supplier Quote Comparison Workbook
2
Free scoring template by Heizen · heizen.work · Sample data is made up for illustration
3
4
What this workbook doesTurns supplier quotes in different currencies, units and freight terms into one landed cost per unit, scores each supplier on weighted criteria, flags gaps, and records who approved the award.
5
Step 1 · SettingsEnter the item, the quantity you need, your base currency, exchange rates and the weights. Agree the weights BEFORE you open the quotes. Weights must add up to 100%.
6
Step 2 · QuotesType each quote exactly as the supplier sent it: price, currency, unit, freight, lead time, payment terms, capacity and validity. Up to 10 suppliers.
7
Step 3 · ComparisonNothing to type (the tab is protected, no password, so formulas cannot be overwritten by accident). Formulas convert currency and unit, add freight, score each criterion out of 100, apply the weights and rank the suppliers. Check the Flags column.
8
Step 4 · Decision logRecord the recommended supplier, the award, the reason if it is not the lowest landed cost, and who approved it.
9
Field dictionaryEvery column explained: what it means, where it comes from, and the formula used.
10
Colour keyYellow cells = you type. White cells = formulas, do not overwrite. Sand cells in Flags = needs a person.
11
Sample dataThe five bids (A to E) come from our worked example "Compare Supplier Quotations Automatically: Worked Example with 5 Bids". Clear the yellow cells on Quotes to start your own.
12
LimitsA spreadsheet has no audit trail and breaks easily when rows are pasted. When you run many RFQs a month, quotes arrive in many formats, or awards need approvals, move this logic into a workflow. Heizen builds that around your ERP: heizen.work
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100