# Comparing suppliers: which making charge is cheaper?

> Free Excel and PDF sheet to compare gold suppliers: making charge per gram, discount and payment terms, the effective rate and the total for the same order.

Source: https://qintar.app/en/sheets/shop-supplier-compare.html
Language: English
قنطار (Qintar)، qintar.app

---

Free sheet for goldsmiths and shop owners · For an order of a given weight, which supplier has the lowest real making charge after the discount?

Every supplier quotes a different making charge, with a discount or payment terms on top. This sheet puts the offers side by side for the same order and works out the effective making charge.

[Download PDF130 KB](https://qintar.app/en/sheets/shop-supplier-compare.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/shop-supplier-compare.xlsx)

Opens in Excel, or upload the file to Google Drive and open it with Google Sheets. You type in the yellow cells. [Or try it online without downloading](https://qintar.app/en/tools/shop-supplier-compare.html).

![Preview of the first page of the "Comparing suppliers: which making charge is cheaper?" sheet, with the table and the worked example](https://qintar.app/en/sheets/shop-supplier-compare.png)

## How to use it

1. **The order:** The weight you are comparing on.
2. **The offers:** The making charge, discount and payment terms of each supplier.
3. **The calculation:** The effective making charge and the total.
4. **The notes:** Returns and delivery.
5. **The decision:** The numbers together with the terms.

## Example The calculation with numbers

Order weight, g (example): 500.000

| Supplier | Making charge per gram | Discount % | Payment terms (days) | Effective making charge per gram | Total making charge for the order |
| --- | --- | --- | --- | --- | --- |
| Example: Supplier A | 65.00 | 0.0% | 30 | 65.00 | 32,500.00 |
| Example: Supplier B | 70.00 | 10.0% | 0 | 63.00 | 31,500.00 |
| Example: Supplier C | 60.00 | 0.0% | 15 | 60.00 | 30,000.00 |

Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.

## The calculation

- Effective making charge per gram = making charge per gram × (1 − discount).
- Total making charge for the order = effective making charge × order weight.
- Payment terms, returns and quality are not in the figure: compare them yourself.

## Terms used on this sheet

- **Supplier:** The wholesaler or workshop that sells finished jewelry to a shop (مورد).
- **Making charge:** The fee for the work, per gram (مصنعية). Between shop and supplier it is usually settled in pounds, while the gold is settled by weight.
- **Payment terms:** How many days the supplier gives you to pay. Zero means payment on delivery.
- **Effective making charge:** The making charge per gram after the discount: what you really pay.

## Read more

- [Comparing gold suppliers: the real making charge](https://qintar.app/en/articles/compare-gold-suppliers.html)A step-by-step guide with a worked example.
- [Supplier comparison: the real making charge on an order](https://qintar.app/en/tools/shop-supplier-compare.html)The same sheet online, with today's prices.

## Frequently asked questions

**Does the sheet put a value on the payment terms?**

No. The payment terms are written next to the figure so you can compare them, but they are not part of the calculation.

**Is the gold itself included?**

No. The comparison is on the making charge only, because the gold is settled by weight or at the market price.

**What is the discount taken from?**

From the making charge. If a supplier discounts in a different way, change the formula.

**Why compare on the same order weight?**

Because the total in pounds is what you will pay. A difference of a few pounds per gram becomes a real sum on hundreds of grams.

Prices and calculations are for information only. They are not financial advice, an offer to buy or sell, or a religious ruling. Check tax matters with your accountant.

**Live prices in the app.** The Qintar app shows gold and silver buy and sell prices in Egypt, your holdings at today's price, and a zakat calculator. Free, with no ads.

[Open the web app](https://qintar.app/app/) [Get it on Google Play](https://play.google.com/store/apps/details?id=app.qintar)

## More free sheets

- [Buying gold at several price levels](https://qintar.app/en/sheets/buy-sell-levels-plan.html)If I split my buying over several prices, what will my average cost be?
- [Order production tracker: which stage ran late?](https://qintar.app/en/sheets/workshop-production-tracker.html)How many days did each order spend in each stage, and is it late against what was agreed?
- [Gold to silver ratio: a daily log](https://qintar.app/en/sheets/gold-silver-ratio-log.html)How many grams of silver does a gram of gold buy today, and how does that ratio move?

[All free sheets](https://qintar.app/en/sheets/)
