- Qintar
- Calculators
- Shabka budget calculator
Shabka budget calculator
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.
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
- Budget and prices: The budget and today's selling price per gram.
- The pieces: Each piece with its karat, weight and making charge.
- The price: The sheet prices each piece.
- The total: The running total after each piece, against the budget.
- 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:
| 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 |
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
- 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.
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
- Monthly gold savings plan calculatorIf I put a fixed amount into gold every month, how many grams do I build up, and what is my average cost?
- Gold savings goal calculator: the monthly amountI want to reach a set number of grams in a set time. How much should I save each month?
- Family gold register: pieces and value per personHow many grams of gold does the family own, who holds them, and what are they worth?
- Inherited gold calculator: value of each shareIf the shares are known from the official document, what is each person's share of the gold's value worth?
- Entry cost compared: bar, gold pound or jewelryFor which option must the price rise the least before I get my money back?