Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Break-even calculator for a gold shop

Break-even calculator for a gold shop

How many grams must I sell each month to cover the shop's costs?

Rent, salaries and electricity are paid whether you sell or not. This sheet tells you how many grams must be sold each month and each day to cover those costs, and how many to leave a profit. This calculator is the same as the "Break-even: how many grams to sell each month?" 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.

Monthly costAmountGrams of sales needed to cover itDelete

Result

Who this calculator is for

This is the online version of the "Break-even: how many grams to sell each month?" sheet, made for goldsmiths and shop owners. A sheet that adds up the shop's fixed monthly costs and divides them by your average profit per gram. It shows how many grams you must sell each month and each day to cover the costs, and how many to reach the profit you want.

The question it answers: How many grams must I sell each month to cover the shop's costs?

How to use it

  1. Profit per gram: What you earn on a gram, on average.
  2. The costs: One line per fixed monthly cost.
  3. Break-even: The grams that cover the costs.
  4. Per day: The share of each working day.
  5. The target: The grams that cover the costs and the profit you want.

Worked example

Your average profit per gram (example): 150.00 · Working days in the month (example): 26 · Profit you want each month above costs (example): 20,000.00

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

ResultValue
Total fixed costs45,600.00
Break-even grams per month304.000
Break-even grams per day11.692
Target grams per month (costs + profit)437.333
Target grams per day16.821

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

Break-even
The level of sales at which profit exactly covers the costs, with nothing left over.
Fixed costs
Costs paid every month whatever the sales: rent, salaries, utilities, security.
Making charge
The fee for the work on a piece, charged per gram (مصنعية). It is a main source of a shop's profit.

Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: Break-even for a gold shop: grams to sell to cover costs.

Frequently asked questions

How do I find my profit per gram?

From the monthly profit sheet: profit before expenses ÷ grams sold. Or from the average making charge you collect minus what you pay for it.

Why not use the gram price?

Because the price of the gold itself is not profit: you buy it and you sell it. What covers the costs is the margin you earn on each gram.

What if I sell less than the break-even?

Then that month the costs were bigger than the profit. The sheet shows how many grams each cost needs, so you know where to start.

Why is the profit per gram so small next to the gold price?

Because most of what a customer pays is the gold itself, which the shop also had to buy. The figure in the example is an illustration; type your own.

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