Skip to content

UAE Restaurant Operations Toolkit · Pricing · VAT · prime cost

UAE Restaurant Menu Price Increase Calculator

Test a price rise before the menu is reprinted: the employment-cost bridge, the prime-cost target and, item by item, how much volume a new price can afford to lose.

Download the Excel workbook XLSX · 22 KB · free, nothing stored What is in the file, and the complete toolkit ↓
Who it is for
Owners, managers and finance leads who are about to raise prices — after a wage change, a supplier increase or a delivery-fee change — and want the arithmetic before the guests react.
The problem it removes
A price increase is usually decided on the cost that triggered it, not on what the menu can bear. Raise a AED 42 dish to AED 46.20 and lose a tenth of its volume, and the extra contribution can be almost nothing — the sheet shows that before the reprint.
What you leave with
The weekly employment-cost change by role, the required net sales at your target prime-cost ratio, an indicative uniform price change, and for every item a new contribution per unit, the expected weekly change and the maximum volume loss the new price can absorb.

The files

Download Excel workbook XLSX · 22 KB · 5 sheets
Format
XLSX
Version
UAE edition 1.0
Reviewed
28 September 2026
Access
Free · direct · nothing stored

Files are the published copies of GGB's UAE edition: formulas and formatting intact, editable, with a link back to this page for updates. The complete toolkit is also one download — all files as a ZIP (759 KB).

What is inside — previews from the filerendered from the published file
The Example menu sheet: a Dubai café lunch row showing VAT rate, current and new price, units, expected unit change, costs, net prices, contributions and the weekly contribution change.
Sheet “Example menu” — one fictional scenario row, columns A to P
The Prime cost sheet: weekly net sales, food and beverage cost, employment cost links, the editable target ratio and the required-sales calculation.
Sheet “Prime cost” — required sales at the target prime-cost ratio

Contents

  • Start here — the basis, the VAT treatment per item and the review-before-launch list
  • Employment cost — twelve roles, headcount, current and proposed monthly cost per person, weekly bridge (monthly × 12 ÷ 52)
  • Prime cost — weekly net sales, food & beverage cost, employment cost linked from the bridge, an editable target ratio, required sales and the indicative uniform price change
  • Menu scenarios — twenty item rows: VAT rate, current and new price incl. VAT, units, expected unit change, variable cost per unit, and the calculated net prices, contributions, weekly change and maximum volume loss
  • Example menu — one fictional Dubai café lunch row with every formula live

How to use it — three steps

  1. On Employment cost, enter headcount and the current and proposed monthly cost per person for each role, including allowances and consistently allocated employer costs. The weekly totals link into the prime-cost sheet.
  2. On Prime cost, enter actual weekly net sales (excluding VAT) and food & beverage cost, and set your own target ratio. Read the required sales and the indicative uniform price change.
  3. On Menu scenarios, enter each item’s current and new customer price including VAT, its units a week, your expected unit change and its variable cost per unit. Read the weekly contribution change and the maximum volume loss column before you decide.
Worked example · illustrative, not a client resultthe workbook's own fictional example sheet

The fictional café lunch in the Example menu sheet

A AED 42 lunch (5% VAT) moves to AED 46.20. Net of VAT that is AED 40 to AED 44. The variable cost per unit rises from AED 14 to AED 15, so contribution per unit goes from AED 26 to AED 29. Today it sells 100 a week; the scenario assumes 10% fewer.

Try the row livethe workbook's arithmetic · on this device · nothing stored

Up AED 10.00 a week at the units you expect.

Net price now → new
AED 40.00 → AED 44.00
Contribution per unit now → new
AED 26.00 → AED 29.00
Expected units a week
90
Price change
10%
Max volume loss to hold contribution
10.3%

Contribution = net price less the entered variable cost per unit. It is not gross profit, operating profit or cash. Same arithmetic as the workbook's scenario row; only the figures you type, on this device.

Ninety units at AED 29 contribute AED 2,610 a week against AED 2,600 today: the 10% rise with 10% fewer units is worth AED 10 a week. The dish has moved sideways.

The maximum volume loss column says the new price can absorb a loss of about 10.3% of units before contribution falls below today’s. A 10% loss sits right at that edge; a 15% loss would leave the dish worse off than before the increase.

Contribution here is net price less the entered variable cost — it is not gross profit, operating profit or cash. Fixed costs, rent and the employment bridge sit on the other sheets, which is why the price and the prime-cost target are read together.

Common mistakes

  • Entering prices net of VAT in a column that asks for the customer price including VAT — the net price is calculated from it.
  • Applying a universal payroll-tax percentage: the UAE has no such assumption in this sheet. Enter the employer costs that actually apply to each role.
  • Counting the employment cost twice — once on the bridge and again inside the prime-cost sheet’s costs.
  • Reading the indicative uniform price change as a recommendation. It assumes unchanged volume, mix and costs; the menu-scenario rows are where the demand risk is tested.
  • Forgetting the fees that change with price — a packaging or platform fee that scales with the ticket belongs in the new variable cost.

What it does not do

  • Expected unit change is your scenario, not a forecast: the sheet does not predict demand.
  • The prime-cost model holds weekly costs constant and covers food, beverage and employment only — it is not a full break-even model.
  • Municipality, tourism or service charges are not modelled automatically; where they apply, they are entered as part of the cost basis.

Questions

Which VAT rate do I select?
The UAE standard rate is 5% (Ministry of Finance, checked 28 Sep 2026). Select 0% only where it genuinely applies, including a non-registered business model, and confirm the treatment with your finance owner.
What does “maximum volume loss to hold contribution” mean?
The share of units the item can lose at the new price before its weekly contribution falls below today’s. A negative value means the new row needs volume growth to hold contribution.
Is the required-sales figure my break-even?
No. Required sales = proposed prime cost ÷ your target ratio. It covers food, beverage and employment against a target, not rent, utilities or every other cost. Use the Break-Even Calculator for the whole cost base.
Can I test a delivery-platform price separately from dine-in?
Yes — enter the delivery version of the item as its own row with its platform fees inside the variable cost, and give it its own units and expected change.

Official references the template uses

Prepared by GGB Consulting as an operating template. Not legal, tax or financial advice; HR and finance owners confirm the treatment that applies to the employer and the emirate.

Talk to us Call WhatsApp GGB