- Qintar
- Free sheets
- What a piece costs the workshop
What a piece costs the workshop
To set a making charge that pays, you need to know what a piece really costs you. This sheet adds up the gold, the loss, the work and the stones, and gives the work cost per gram to compare with your making charge.
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.

How to use it
- Fixed costs: The cost per gram of each karat and the labor rate per hour.
- The piece: The karat, the weight, the estimated loss and the hours.
- Extras: Stones and any other cost.
- The result: The total cost and the cost per gram.
- Compare: Compare the work cost per gram with the making charge you take.
Example The calculation with numbers
Gold cost, 1 g of 24K (example): 7,009.37 · Gold cost, 1 g of 21K (example): 6,160.25 · Gold cost, 1 g of 18K (example): 5,259.00 · Labor rate per hour (example): 120.00
| Piece | Karat | Weight (g) | Gold | Cost of the loss | Labor | Total cost | Work cost per gram (without the gold) |
|---|---|---|---|---|---|---|---|
| Example: openwork bracelet | 21 | 18.000 | 110,884.50 | 3,326.54 | 720.00 | 114,981.04 | 227.59 |
| Example: ring with a stone | 18 | 5.000 | 26,295.00 | 1,051.80 | 360.00 | 28,606.80 | 462.36 |
| Example: plain chain | 21 | 12.000 | 73,923.00 | 1,108.85 | 180.00 | 75,211.85 | 107.40 |
| Result | Value |
|---|---|
| Total cost | 218,799.68 |
| Total weight (g) | 35.000 |
| Total cost of work and loss | 7,697.18 |
Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.
The calculation
- Gold = weight × cost per gram of the karat. Loss = gold × the loss % you estimate.
- Labor = hours of work × hourly rate.
- Total = gold + loss + labor + stones + other costs. Work cost per gram = (total − gold) ÷ weight.
Terms used on this sheet
- Making charge
- The fee per gram that a customer pays for the work on a piece (مصنعية), on top of the gold price.
- Loss
- The gold that disappears in melting, filing and polishing, as a percentage of the gold used.
- Openwork
- A design with cut-out patterns, which takes many more hours than a plain piece.
Read more
- What a gold piece costs: your real making chargeA step-by-step guide with a worked example.
- Piece cost calculator for a gold workshopThe same sheet online, with today's prices.
Frequently asked questions
How do I work out the hourly rate?
Divide the craftsmen's wages and the workshop's expenses by the hours worked in a month. The figure is yours; the one in the example is an illustration.
What loss % should I type?
From your own experience, or from Qintar's casting batch and craftsman account sheets. The sheet does not suggest a figure.
What do I compare the work cost per gram with?
With the making charge per gram you sell at. If the making charge is lower than the cost, the piece is not making money.
Why is the gold priced at its cost and not the selling price?
The sheet works out what the piece costs the workshop. The selling price, with the making charge and the margin, comes after.
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
- Customer orders and depositsWhat does each order cost, how much has the customer paid, and what is still due?
- Customer repairs: weight in and weight outDid the piece go back to the customer at the same weight? And what does the repair cost?
- Display stock: pieces and weight by categoryHow many pieces and grams do I have in each category and karat, and what are they worth?