Operations template
Supplier Price Comparison Template
Pick the cheapest supplier on total cost, not just price. The best option is highlighted by a formula.
Opening a template uses no credits.
What's inside
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Supplier | Unit price | Quantity | Shipping | Total |
| 2 | Supplier A | 42 | 500 | 1,500 | =B2*C2+D2 |
| 3 | Supplier B | 39 | 500 | 3,500 | =B3*C3+D3 |
| 4 | Supplier C | 44 | 500 | 0 | =B4*C4+D4 |
| 5 | Cheapest | =INDEX(A2:A4,MATCH(MIN(E2:E4),E2:E4,0)) | =MIN(E2:E4) |
Preview with sample numbers. Formulas are shown in green.
The formulas, explained
E2 =B2*C2+D2
Unit price times quantity, plus shipping.
B5 =INDEX(A2:A4,MATCH(MIN(E2:E4),E2:E4,0))
INDEX/MATCH returns the supplier with the lowest total.
Make it yours by asking
Try a request like this in Tabstra:
"Create a supplier comparison with supplier, unit price, quantity, shipping, total cost and the cheapest option"