# Shabka budget: what can the budget buy? | Free sheet

> Free Excel and PDF shabka budget sheet: price each piece from weight, karat, selling price, making charge and VAT, then compare the total with your budget.

Source: https://qintar.app/en/sheets/bride-shabka-budget.html
Language: English
قنطار (Qintar)، qintar.app

---

# Shabka budget: what can the budget buy?

Free sheet for individuals · With this shabka budget, which pieces can I buy, and how many grams?

Before you go shopping for the shabka, find out what the budget can buy. This sheet prices each piece at today's price with its making charge, adds them up, and compares the total with the budget.

[Download PDF138 KB](https://qintar.app/en/sheets/bride-shabka-budget.pdf)[Download Excel60 KB](https://qintar.app/en/sheets/bride-shabka-budget.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/bride-shabka-budget.html).

![Preview of the first page of the "Shabka budget: what can the budget buy?" sheet, with the table and the worked example](https://qintar.app/en/sheets/bride-shabka-budget.png)

## How to use it

1. **Budget and prices:** The budget and today's selling price per gram.
2. **The pieces:** Each piece with its karat, weight and making charge.
3. **The price:** The sheet prices each piece.
4. **The total:** The running total after each piece, against the budget.
5. **Adjust:** Change the weights until the total fits the budget.

## Example The calculation with numbers

Budget (example): 250,000.00 · Selling price, 1 g of 24K (example): 7,032.37 · Selling price, 1 g of 21K (example): 6,180.25 · Selling price, 1 g of 18K (example): 5,276.00 · VAT on the making charge (example 14%): 14%

| Piece | Karat | Weight (g) | Making charge per gram | Price of the piece | Running total | Budget |
| --- | --- | --- | --- | --- | --- | --- |
| Example: two wedding bands | 21 | 9.000 | 100.00 | 56,648.25 | 56,648.25 | Within budget |
| Example: mahbas ring | 21 | 4.000 | 120.00 | 25,268.20 | 81,916.45 | Within budget |
| Example: chain and pendant | 21 | 12.000 | 150.00 | 76,215.00 | 158,131.45 | Within budget |
| Example: bracelet | 21 | 14.000 | 130.00 | 88,598.30 | 246,729.75 | Within budget |

| Result | Value |
| --- | --- |
| Shabka total | 246,729.75 |
| Left from the budget | 3,270.25 |
| Total weight (g) | 39.000 |
| Result | The shabka fits the budget |

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

## The calculation

- Price of a piece = weight × (selling price per gram of the karat + making charge × (1 + VAT)).
- Running total = the sum of the pieces from the first line down.
- Left = budget − shabka total.

## Terms used on this sheet

- **Shabka:** The engagement gold a groom gives his bride in Egypt (الشبكة): often wedding bands with other pieces.
- **Mahbas:** A ring worn next to the wedding band (محبس), often part of the shabka.
- **Selling price:** The price per gram a shop charges when you buy. It is higher than the buying price.
- **Making charge:** The fee for the work, per gram (مصنعية), with 14% VAT on it.

## Read more

- [Shabka budget: pricing the pieces before you go shopping](https://qintar.app/en/articles/shabka-budget-guide.html)A step-by-step guide with a worked example.
- [Shabka budget calculator](https://qintar.app/en/tools/bride-shabka-budget.html)The same sheet online, with today's prices.

## Frequently asked questions

**What making charge should I type?**

Ask the jeweler for the making charge per gram on each piece and type it. The figures in the example are illustrations; the usual current ranges are in Qintar's calculators.

**Why the selling price and not the buying price?**

Because you are buying from the jeweler, you pay the selling price. The buying price is what a jeweler pays you when you sell.

**Is VAT charged on all the gold?**

No. VAT is charged on the making charge only, and the sheet works it out that way.

**What is a shabka?**

In Egypt, the shabka is the gold jewelry a groom gives his bride at the engagement. Its pieces and budget are agreed between the two families; the sheet only does the arithmetic.

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

- [Customer orders and deposits](https://qintar.app/en/sheets/shop-orders-deposits.html)What does each order cost, how much has the customer paid, and what is still due?
- [Customer repairs: weight in and weight out](https://qintar.app/en/sheets/shop-repairs-log.html)Did the piece go back to the customer at the same weight? And what does the repair cost?
- [Display stock: pieces and weight by category](https://qintar.app/en/sheets/shop-inventory-by-category.html)How many pieces and grams do I have in each category and karat, and what are they worth?

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