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

> Free Excel and PDF break-even sheet for a gold shop: how many grams to sell each month and day to cover rent, salaries and costs, and to reach a target.

Source: https://qintar.app/en/sheets/shop-break-even.html
Language: English
قنطار (Qintar)، qintar.app

---

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 KB](https://qintar.app/en/sheets/shop-break-even.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/shop-break-even.xlsx)

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](https://qintar.app/en/tools/shop-break-even.html).

![Preview of the first page of the "Break-even: how many grams to sell each month?" sheet, with the table and the worked example](https://qintar.app/en/sheets/shop-break-even.png)

## 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 cost | Amount | Grams of sales needed to cover it |
| --- | --- | --- |
| Example: rent | 15,000.00 | 100.000 |
| Example: salaries | 24,000.00 | 160.000 |
| Example: electricity and water | 2,500.00 | 16.667 |
| Example: internet and phones | 600.00 | 4.000 |
| Example: insurance and security | 1,500.00 | 10.000 |
| Example: other costs | 2,000.00 | 13.333 |

| Result | Value |
| --- | --- |
| Total fixed costs | 45,600.00 |
| Break-even grams per month | 304.000 |
| Break-even grams per day | 11.692 |
| Target grams per month (costs + profit) | 437.333 |
| Target grams per day | 16.821 |

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

## The calculation

- Break-even grams = total fixed costs ÷ your average profit per gram.
- Per day = grams per month ÷ working days.
- Target grams = (costs + the profit you want) ÷ profit per gram.
- Profit per gram = what you earn on a gram after its cost (making charge and price margin), not the gram price.

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

- [Break-even for a gold shop: grams to sell to cover costs](https://qintar.app/en/articles/gold-shop-break-even.html)A step-by-step guide with a worked example.
- [Break-even calculator for a gold shop](https://qintar.app/en/tools/shop-break-even.html)The same sheet online, with today's prices.

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

[Open the web app](https://qintar.app/app/) [Get it on Google Play](https://play.google.com/store/apps/details?id=app.qintar)

## More free sheets

- [Buying used gold from customers: a daily log](https://qintar.app/en/sheets/shop-used-gold-buying.html)On average, what did I pay today for each gram of pure gold in the used gold I bought?
- [Selling on installments: payment, mark-up and balance](https://qintar.app/en/sheets/shop-installment-sales.html)If I sell on installments, what is the monthly payment, and how much will the customer pay in the end?
- [Zakat for a gold shop: the base and the nisab](https://qintar.app/en/sheets/shop-zakat.html)How much is the shop's zakat this year?

[All free sheets](https://qintar.app/en/sheets/)
