Retail Markdown, Promotion and Bundle Calculator

A discount feels like a sale but it is a pay cut on every unit you sell. A 20 percent discount on a product with a 40 percent margin means you must sell half as many units again just to earn the same profit. Most shop owners print the sign first and find out later.

This app does that arithmetic before the sign is printed. Discount impact takes one product and any discount and shows the new price, the new margin and how many more units you must sell to break even. The Promotion list applies one discount to many products, marks the ones that fall below your margin floor or lose money, and rounds the promotional prices to AED conventions. Bundles and offers prices a bundle, buy N get M free, and second item off, with the true margin. The Clearance schedule builds a dated markdown ladder for slow stock with the expected recovery and a never-below-cost option. Price rounding rounds any price down, up or to the nearest .99, .95, .90, .50, whole dirham, or a price ending in 9 or 5.

What is inside:

• Discount impact, Promotion list, Bundles and offers, Clearance schedule, Price rounding and Settings tabs
• Margins worked out on the price excluding VAT, with the VAT rate and your margin floor as settings
• CSV import of products, CSV export of the promotion list, JSON backup, print
• A worked example for a small shop with eight products

Who it is for: shops, groceries, boutiques and gift stores that run promotions and clearances.

What it is not: the break-even uplift assumes the same cost and no effect on other products. Real promotions also move customers between products and pull sales forward, so use the number as a hurdle a promotion has to clear, not a forecast. Consumer protection rules about sale pricing apply to how you advertise: check the current rules with your emirate's economic department.

How it differs: the Pricing and Margin Calculator Suite in the catalogue is a set of Excel tools including discount impact and bundle pricing. This app adds a promotion list with margin-floor warnings, buy-N-get-M and second-item offers, a clearance ladder and AED price-point rounding in one browser tool.

Tested: break-even uplift, margins, bundle and offer maths, clearance schedules and all rounding modes were compared with a separate Python implementation on randomised cases, 3,549 values, with no differences. 61 scripted browser checks cover every tab, validation, CSV import, backup restore, print and the 375 and 1280 pixel layouts, with no console errors. Browser tests ran in Chromium and WebKit; Firefox, a real phone, a real printer and a real scanner were not available, so they were not tested.