Global tax & currency
Presets fill VAT/GST and currency; lock keeps all tools consistent.
Formula list
- Promo Price:
markdown% = (full_inc − promo_inc) / full_inc;GM% = (promo_ex − cost_ex) / promo_ex - Max Discount for Target GM:
min_promo_ex = cost_ex / (1 − targetGM);promo_inc = min_promo_ex × (1+tax);max % off = 1 − promo_inc / full_inc - Discount for Target Price:
discount% = 1 − target_inc / full_inc;GM% = (target_ex − cost_ex) / target_ex - Multi‑Buy Deals: effective unit price by deal;
markdown% = 1 − eff_inc / full_inc;GM% = (eff_ex − cost_ex) / eff_ex - Cost from Retail: if retail inc tax:
price_ex = retail_inc / (1+tax); if retail ex tax:price_ex = retail_ex. Thencost_ex = price_ex × (1 − targetGM). - Margin from Cost:
price_ex = retail_inc / (1+tax);GM% = (price_ex − cost_ex) / price_ex;Markup% = (price_ex − cost_ex) / cost_ex - RRP from Cost:
price_ex = cost_ex / (1 − targetGM);RRP_inc = price_ex × (1+tax) - Weeks Cover:
cover = closing_units ÷ weekly_units - Sell‑through:
st% = units_sold ÷ opening_units - Annual Sales:
gross_inc = RRP_inc × units;net_ex = gross_inc ÷ (1+tax) - Stock vs Store % mix:
mix% = store_stock ÷ total_stock - Store Sales Mix: per‑store share =
store_sold ÷ total_sold; remaining =opening − total_sold; sell‑through =total_sold ÷ opening - Product Share of Total:
share% = product_sales_TY ÷ total_sales_TY - % Diff TY vs LY:
Δ% = (sales_TY − sales_LY) ÷ sales_LY
Tax conversions:
inc = ex × (1+tax); ex = inc ÷ (1+tax). Enter tax as 20 or 0.20.Promo Price → Markdown% & GM%
Max Discount to Keep Target GM%
Discount Needed for Target Price
Multi‑Buy Deals → Effective Price & GM%
Cost price from Retail & Target GM%
If you choose “Inc tax”, the tax rate should be the one already included in the retail value (not an extra charge).
Margin & Markup from Cost & Retail
RRP (inc tax) from Cost & Target GM%
Weeks Cover
Sell‑through %
Annual Sales (quick)
Stock vs Store % mix
Store Sales Mix
| Store | Units Sold | Share of Total | |
|---|---|---|---|
| Total sold | — |
Status: loading…
% Difference TY vs LY
Notes
- Presets simplify local rules. Adjust for reduced rates or state taxes if needed.
- GM% always uses EX‑tax retail. For US‑style sales tax, set “Prices include tax?” to “No”.