Product Pricing & Margin Calculator – Free Excel Template for Retail Stores
Price with confidence – never sell below your real cost again. Turn supplier cost into a smart shelf price: adds shipping & customs %, applies your target margin, rounds to a clean IQD price (250 /...
Price with confidence – never sell below your real cost again. Turn supplier cost into a smart shelf price: adds shipping & customs %, applies your target margin, rounds to a clean IQD price (250 / 500 / 1,000), shows markup and the margin left after any discount – so sales campaigns never eat your profit.
Table Of Content

Why it matters
In a clothing, perfume or grocery store, profit is decided by small numbers: a few thousand dinars missing from the drawer every day, a supplier invoice paid twice, a discount that eats the whole margin. Stores that write these numbers down every day see problems weeks earlier and make calmer decisions.
What’s inside the template
You fill in: SKU, Product, Category, Supplier Cost / unit, Shipping & Customs %, Target Margin %, Round to (IQD), Discount %.
Calculated automatically:
- Landed Cost
- Shelf Price – Landed cost ÷ (1 – target margin), rounded up
- Actual Margin %
- Markup %
- Sale Price
- Margin after Discount
How to use it, step by step
- Enter the unit cost from the supplier and the shipping/customs % on top of it.
- Set your target margin (e.g. 45% for clothing, 35% for perfume, 15% for grocery).
- Choose the rounding step (250, 500 or 1000 IQD) – the final price is rounded up.
- Try a discount % to see the margin left during a sale. Margins under 20% turn red.
The dashboard: numbers to watch
- Products priced
- Average margin
- Lowest margin
- Items under 20% after discount
Summary tables: Average margin by category.
Example from the template
| SKU | Product | Markup % | Sale Price | Margin after Discount |
|---|---|---|---|---|
| CL-0451 | Women’s linen dress | 83.5% | 25,900 | 22.2% |
| PF-0102 | Oud perfume 100 ml | 54.8% | 48,150 | 28.2% |
| GR-2210 | Basmati rice 5 kg | 17.8% | 11,750 | 15.1% |
Download the template free
Free, no registration. Two versions: English and Arabic (right-to-left). Works in Excel, Google Sheets and WPS.
Browse all 60 templates in the ProSite Library
Need help running your store?
ProSite fits out, opens and runs retail stores in Baghdad and Erbil – store fit-out, visual merchandising, operations teams, IT setup and manager training. Call or WhatsApp us on +964 780 930 9998.




[…] Size Run & Broken-Size Floor Check (Clothing) – Free Excel Template for Retail Stores Product Pricing & Margin Calculator – Free Excel Template for Retail Stores Home/Retail Guides/Daily Cash Drawer Reconciliation – Free Excel […]