Qintar logoQintar
  1. Qintar
  2. Free sheets
  3. Shabka budget: what can the budget buy?

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 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 "Shabka budget: what can the budget buy?" sheet, with the table and the worked example

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%

PieceKaratWeight (g)Making charge per gramPrice of the pieceRunning totalBudget
Example: two wedding bands219.000100.0056,648.2556,648.25Within budget
Example: mahbas ring214.000120.0025,268.2081,916.45Within budget
Example: chain and pendant2112.000150.0076,215.00158,131.45Within budget
Example: bracelet2114.000130.0088,598.30246,729.75Within budget
ResultValue
Shabka total246,729.75
Left from the budget3,270.25
Total weight (g)39.000
ResultThe 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

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

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.

More free sheets

All free sheets