[vlp_price_calculator_results_table]
Modellname
Referencenumber
Purchaseprice
Flightprice
Purchaseprice total
Margin Seller
Sellprice w/tax
Sellprice me
Profit
Link
Bag 1
CRV6HN
10000 €
600 €
11024 €
10 %
16800 €
12759,91 €
1735,91 €
Link

Calculation Purchaseprice total:

Purchaseprice + Flightprice = Purchaseprice without duty

Purchaseprice without duty / 100 * 1. duty = Purchaseprice total

Example:

Purchaseprice: 10000 €

Flightprice: 600 €

Duty: 4%

10000 + 600 = 10600 €

10600 € *1.04 = 11024 € 

Sellprice me:

Sellprice with tax / 19 % tax

Sellprice net x 100 – 0.10 margin seller

16800 € / 1.19 = 14177,68 €

14177,68 € x 0,9 = 12759,91 €

Profit:

Sellprice me – Purchaseprice total

12759,91 € – 11024 € = 1735,91 €

Editable Columms

Purchase Price

Sellprice w/tax 

Change for all rows:

Margin Seller 

Flightprice