Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Display stock calculator: pieces, weight and value per karat

Display stock calculator: pieces, weight and value per karat

How many pieces and grams do I have in each category and karat, and what are they worth?

The stock in the display cases is the largest part of a gold shop's money. This sheet sums it up category by category: how many pieces and grams of each karat, the pure gold, and the value at today's price. This calculator is the same as the "Display stock: pieces and weight by category" sheet. It runs in your browser and saves no data.

Settings and prices

Loading today's prices…

The table

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

CategoryKaratPiecesTotal weight (g)Pure gold (g)Average weight per piece (g)Value at the buying priceDelete

Result

Who this calculator is for

This is the online version of the "Display stock: pieces and weight by category" sheet, made for goldsmiths and shop owners. A table of the stock on display, category by category: the number of pieces and the weight for each karat, the pure gold, the average weight per piece, the value at today's buying price, and a total for each karat.

The question it answers: How many pieces and grams do I have in each category and karat, and what are they worth?

How to use it

  1. The prices: Today's buying price per gram for each karat.
  2. The categories: One line per category and karat, with the number of pieces and the weight.
  3. The calculation: Pure gold, average weight per piece and value.
  4. The totals: Total pieces and weight for each karat.
  5. Compare: Check it against your stock count and books every month.

Worked example

Buying price, 1 g of 24K (example): 7,009.37 · Buying price, 1 g of 21K (example): 6,160.25 · Buying price, 1 g of 18K (example): 5,259.00

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

ResultValue
Total pieces178
Total weight (g)1,623.700
Of which 21K (g)1,366.700
Of which 18K (g)162.000
Of which 24K (g)95.000
Total pure gold (g)1,412.268
Value at the buying price9,937,061.83

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

Display stock
The finished pieces in the shop's cases and window (المعروض), as opposed to scrap or gold at the workshop.
Pure gold
The gold inside an alloy: weight × purity. It lets different karats add up to one figure.
Gold pound
A coin of 8 g of 21K gold (جنيه ذهب), sold in Egypt alongside bars and jewelry.
Buying price
The price at which a shop buys gold. It is lower than the selling price that customers pay.

Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: A gold shop's display stock: grams by category and karat.

Frequently asked questions

Does the value include the making charge?

No. The value is at the buying price of the gold only, so you know what the metal you hold is worth. The making charge belongs in your pricing.

Does this replace a stock count?

No, it is a summary of the display stock. Counting the stock and matching it with the books is done in Qintar's gold stock count and loss sheet.

Why the average weight per piece?

It tells you about the kind of stock you carry. If the average weight of your rings rises or falls, that matters for your next purchases.

Why value at the buying price and not the selling price?

The buying price is what the gold would fetch if it were sold today. It is the cautious figure for what the stock is worth as metal.

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