Pricing and Margin Calculator Suite for UAE Sellers

Most small sellers set prices by copying a competitor or adding a percentage on cost, then wonder why the profit is thin. This workbook gives you the arithmetic for every common pricing decision in one place, with examples you can overwrite.

What is inside:

• Cost-Plus Price List: up to 20 items. Enter purchase or material cost, labour, freight, duty and packaging, an overhead uplift and a markup. It returns the price excluding and including 5% VAT, the profit per unit and the margin on the price, rounded to the step you choose
• Target Margin: the price you need for a margin you want, and a table that converts markup to margin and back (a 60% markup is only a 37.5% margin)
• Discount Impact: how many more units you must sell after a discount to earn the same gross profit (a 20% discount in the example needs about 111% more), and how much volume a price rise can lose before it hurts
• Bundle Pricing: a bundle of up to 8 items with a discount, the bundle margin, the saving the customer sees and the deepest discount that keeps a margin floor
• VAT and Shelf Price: a converter and a planner that rounds to a whole dirham, a half dirham or a price ending in 9, and shows the margin you really get
• Channel Price: the price needed in your own shop, on a marketplace and in B2B after commission, payment fees, advertising, returns and delivery
• Price Test Log: record each price change and see whether weekly gross profit went up

Who it is for: owners, e-commerce and marketplace sellers, retailers, trading companies, freelancers and service firms in the UAE who set prices without a finance team.

What it is not: it does not know your market, so a price with the right margin may still not sell. The commissions and fees in the example are placeholders: use each platform's current rate card. It does not give tax advice and does not model cash, stock or staff time.

Time saved: re-working a price list, a discount or a marketplace price by hand is slow and easy to get wrong. With the sheets set up it takes minutes per decision. The real benefit is avoiding prices that lose money.

Requirements: Microsoft Excel 2016 or later, Google Sheets or LibreOffice Calc.