Example
Excise Duty Management
•
Article
•
4/29/2023
•
The following data are used:
- Price List Price:€10.00
- Discount:20%
- Excise Duty:€6.00
Discount Based on Price excluding Excise
If the Price Including Excise toggle is turned off, then the discount is calculated based on the price excluding excise.
| Price Agreement Incl. Excise | Yes | Yes | No | No |
|---|---|---|---|---|
| New Price Including Excise | No | Yes | No | Yes |
| Start Price | €10.00 | €10.00 | €10.00 | €10.00 |
| Excise Amount | €6.00 | €6.00 | €6.00 | €6.00 |
| Price Excluding Excise | €4.00 | €4.00 | €10.00 | €10.00 |
| Price Including Excise | €10.00 | €10.00 | €16.00 | €16.00 |
| Discount Base Price | €4.00 | €4.00 | €10.00 | €10.00 |
| Discount Amount | €0.80 | €0.80 | €2.00 | €2.00 |
| New Price | €4.00 | €10.00 | €10.00 | €16.00 |
| Discount Amount | €0.80 | €0.80 | €2.00 | €2.00 |
| New Net Price | €3.20 | €9.20 | €8.00 | €14.00 |
| New Discount % | 20.00% | 8.00% | 20.00% | 12.50% |
Discount Based on Price including Excise
If the Price Including Excise toggle is turned on, then the discount is calculated based on the price including excise.
| Price Agreement Incl. Excise | Yes | Yes | No | No |
|---|---|---|---|---|
| New Price Including Excise | No | Yes | No | Yes |
| Start Price | €10.00 | €10.00 | €10.00 | €10.00 |
| Excise Amount | €6.00 | €6.00 | €6.00 | €6.00 |
| Price Excluding Excise | €4.00 | €4.00 | €10.00 | €10.00 |
| Price Including Excise | €10.00 | €10.00 | €16.00 | €16.00 |
| Discount Base Price | €4.00 | €10.00 | €10.00 | €16.00 |
| Discount Amount | €0.80 | €2.00 | €2.00 | €3.20 |
| New Price | €4.00 | €10.00 | €10.00 | €16.00 |
| Discount Amount | €0.80 | €2.00 | €2.00 | €3.20 |
| New Net Price | €3.20 | €8.00 | €8.00 | €12.80 |
| New Discount | 20.00% | 20.00% | 20.00% | 20.00% |