- Qintar
- Calculators
- Display stock calculator: pieces, weight and value per karat
Display stock calculator: pieces, weight and value per karat
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.
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
- The prices: Today's buying price per gram for each karat.
- The categories: One line per category and karat, with the number of pieces and the weight.
- The calculation: Pure gold, average weight per piece and value.
- The totals: Total pieces and weight for each karat.
- 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:
| Result | Value |
|---|---|
| Total pieces | 178 |
| 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 price | 9,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
- Pure gold = weight × karat purity (24K = 0.999, 21K = 0.875, 18K = 0.75).
- Average weight per piece = total weight ÷ number of pieces.
- Value = weight × today's buying price per gram of the same karat (without the making charge).
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
- Cash close calculator: count the drawer and compareDoes the cash in the drawer match what should be there, or is there a gap?
- Credit book: each customer's balance after every entryHow much does each customer owe, how much have they paid, and what is left?
- Scrap and refining calculator: how much pure gold?How many grams of pure gold are in my scrap, and how much comes back after refining?
- Wholesaler account: balance in pure gold and making chargeHow many grams of pure gold and how many pounds of making charge do I owe the wholesaler?
- Gold shop monthly profit calculatorHow much did the shop make this month after expenses?