I am reseller and my profit is the margin compared to my purchase prices.
| Purchase Order | Quantity | Purchase Unit Price | Sales Unit Price | Sales Margin |
| PO/0001 | 100 | $10,000 | $20,000 | 100% |
| PO/0002 | 1000 | $ 5,000 | $20,000 | 300% |
The goal is to make as many profit as possible but buyers are negotiating the price.
It is important to know how far I can go in offering the best commercial price but not going below a certain margin against the real purchase price of the product.
A customer is interested in buying 500 pieces when he earns the maximum commercial discount.
How far can I go as a reseller? I want to know when negotiating the sales order.
When I use 100 pieces of PO/0001 and 400 pieces of PO/0002, my sales margin is 260% when using the default sales price of $ 20,000.
When I use 500 pieces of PO/0002, my sales margin is 300% when using the default sales price of $ 20,000.
As I bring down the price my sales margin updates. I modify the sales unit price from $ 20,000 to $ 10,000.
When I use 100 pieces of PO/0001 and 400 pieces of PO/0002, only 80% of my sales margin is left.
When I use 500 pieces of PO/0002, my sales margin becomes 100%.
Is it possible to display a weighted margin within a sales order based on the real purchase prices?
