Deal Inputs
Totals Snapshot
Original total
—
Final total
—
Savings: —
Average discount: —
Downloads
CSV and PDF include the example table below plus your added rows.
Example Data & Your Scenarios
| # | Item | Orig Price | Qty | Main % | Extra % | Flat | Ship/item | Tax % | Original Total | Final Total | Savings | Notes |
|---|
Formula Used
- Original total =
price × qty - After main discount =
price × (1 − main%/100) - After extra percent =
afterMain × (1 − extra%/100) - After flat off (per item) =
max(0, afterExtra − flat) - Discounted subtotal =
afterFlat × qty - Shipping total =
shipPerItem × qty - Tax =
(discounted subtotal + shipping total) × tax%/100 - Final total =
discounted subtotal + shipping total + tax - Savings =
(price × qty) − discounted subtotal
This models stacked deals where the extra coupon applies after the main discount. Flat off is applied per item. Totals are clamped at zero to prevent negative prices.
The chart compares original vs final totals per row.