Qintar logoQintar
  1. Qintar
  2. Guides
  3. A gold shop's display stock: grams by category and karat

A gold shop's display stock: grams by category and karat

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

A shop owner needs to know at any moment: how many grams are in the cases, and of which karat? That figure sets what the shop is worth and guides what it buys next.

Summing up by category (rings, chains, bracelets and so on) together with the karat makes the picture clear: where stock is piling up, and where it is running short.

Pure gold brings different karats together into one figure, and the value at the buying price tells you what the metal would fetch if it were sold today.

The average weight per piece is a useful pointer for buying: if customers start asking for lighter pieces, you will see it in the numbers.

What sits in an Egyptian gold shop's cases

A typical Egyptian gold shop sells mostly 21K jewelry, the country's standard karat, alongside 18K pieces, 24K bars and gold pounds (coins of 8 g of 21K). Each has a different purity, so adding up their weights alone tells you little.

Turning each line into pure gold, and valuing each karat at its own buying price, gives one honest total for the whole display.

The example in plain words

The example shop has 178 pieces weighing 1,623.7 g: 1,366.7 g of 21K, 162 g of 18K and 95 g of 24K. Together they hold 1,412.268 g of pure gold, worth EGP 9,937,061.83 at the example buying prices.

The averages tell a story. The 64 rings weigh 4.352 g each on average, the 40 chains 10.3 g and the 22 bracelets 27.1 g. The bracelets alone are worth EGP 3,672,741.05. The 10 gold pounds weigh 8 g each, as they should, and the 12 bars average 7.917 g.

The calculation

Example A 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

CategoryKaratPiecesTotal weight (g)Pure gold (g)Average weight per piece (g)Value at the buying price
Example: rings2164278.500243.6884.3521,715,629.63
Example: chains2140412.000360.50010.3002,538,023.00
Example: bracelets2122596.200521.67527.1003,672,741.05
Example: wedding bands1830162.000121.5005.400851,958.00
Example: bars241295.00094.9057.917665,890.15
Example: gold pounds211080.00070.0008.000492,820.00
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

Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made. Type your own figures in the sheet or the calculator.

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.

Step by step with the sheet

  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.

The sheet is free: Display stock: pieces and weight by category (Excel and PDF), or try it online with today's prices.

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. 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.