- Qintar
- Free sheets
- Comparing suppliers: which making charge is cheaper?
Comparing suppliers: which making charge is cheaper?
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.
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.

How to use it
- The order: The weight you are comparing on.
- The offers: The making charge, discount and payment terms of each supplier.
- The calculation: The effective making charge and the total.
- The notes: Returns and delivery.
- 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 chargeA step-by-step guide with a worked example.
- Supplier comparison: the real making charge on an orderThe 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.
More free sheets
- Buying gold at several price levelsIf I split my buying over several prices, what will my average cost be?
- Order production tracker: which stage ran late?How many days did each order spend in each stage, and is it late against what was agreed?
- Gold to silver ratio: a daily logHow many grams of silver does a gram of gold buy today, and how does that ratio move?