Qintar logoQintar
  1. Qintar
  2. Calculators
  3. Shabka budget calculator

Shabka budget calculator

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. This calculator is the same as the "Shabka budget: what can the budget buy?" sheet. It runs in your browser and saves no data.

Settings and prices

Loading today's prices…

The table

Rows marked "Example" are for illustration: edit or delete them. Empty cells calculate as soon as you type.

PieceKaratWeight (g)Making charge per gramPrice of the pieceRunning totalBudgetDelete

Result

Who this calculator is for

This is the online version of the "Shabka budget: what can the budget buy?" sheet, made for individuals. A sheet that prices each piece of the shabka (the engagement gold) from its weight, karat, selling price, making charge and VAT, keeps a running total against the budget, and shows what is left.

The question it answers: With this shabka budget, which pieces can I buy, and how many grams?

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.

Worked example

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%

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

ResultValue
Shabka total246,729.75
Left from the budget3,270.25
Total weight (g)39.000
ResultThe shabka fits the budget

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

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.

Want to keep your work? Download the sheet as Excel or PDF. For a step-by-step explanation: Shabka budget: pricing the pieces before you go shopping.

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.

Related calculators

All calculators · All free sheets