Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Break-even: how many grams to sell each month?

Break-even: how many grams to sell each month?

Free sheet for goldsmiths and shop owners · 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.

Download PDF132 KBDownload Excel60 KB

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.

Preview of the first page of the "Break-even: how many grams to sell each month?" sheet, with the table and the worked example

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.

Example The calculation with numbers

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

Monthly costAmountGrams of sales needed to cover it
Example: rent15,000.00100.000
Example: salaries24,000.00160.000
Example: electricity and water2,500.0016.667
Example: internet and phones600.004.000
Example: insurance and security1,500.0010.000
Example: other costs2,000.0013.333
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

Figures marked "Example" are for illustration, and the prices are approximate as of the date the sheet was made.

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.

Read more

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

All free sheets