Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Supplier comparison: the real making charge on an order

Supplier comparison: the real making charge on an order

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. This calculator is the same as the "Comparing suppliers: which making charge is cheaper?" sheet. It runs in your browser and saves no data.

Settings and prices

The table

Rows marked "Example" are for illustration: edit or delete them. Empty cells calculate as soon as you type.

SupplierKaratMaking charge per gramDiscount % (%)Payment terms (days)Notes (returns, delivery)Effective making charge per gramTotal making charge for the orderDelete

Who this calculator is for

This is the online version of the "Comparing suppliers: which making charge is cheaper?" sheet, made for goldsmiths and shop owners. A sheet that compares suppliers' offers for the same order: the making charge per gram, any discount, the payment terms, the effective making charge per gram, the total making charge for the order, and notes on each offer.

The question it answers: For an order of a given weight, which supplier has the lowest real making charge after the discount?

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.

Worked example

Order weight, g (example): 500.000

With the example figures in the table above (the rows marked "Example"), the calculator gives:

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

This is exactly the same calculation as in the sheet. Change the numbers in the table above and the result updates by itself.

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.

Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: Comparing gold suppliers: the real making charge.

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.

Related calculators

All calculators · All free sheets