Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Comparing suppliers: which making charge is cheaper?

Comparing suppliers: which making charge is cheaper?

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 KBDownload Excel60 KB

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.

Preview of the first page of the "Comparing suppliers: which making charge is cheaper?" sheet, with the table and the worked example

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

SupplierMaking charge per gramDiscount %Payment terms (days)Effective making charge per gramTotal making charge for the order
Example: Supplier A65.000.0%3065.0032,500.00
Example: Supplier B70.0010.0%063.0031,500.00
Example: Supplier C60.000.0%1560.0030,000.00

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

The calculation

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

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

All free sheets