Need help formula development

[monluigi]

Hello,
need help to develop product price setting formula

• company “A” sells 160 Cans to company “B” at price 0.2$;
• company “B” sells 70 liter of Oil to company “A” at price 7$;
• company “B” sells 150 Canned oil to company “Z” at price 17$;
• for Company “A” Oil price is more important than revenue from Cans, because he consumes oil for production of other more important and profitable business;
• Without Cans Company “B” can’t sell Oil to Company “Z”;
• Company “B” can buy cans only from Company “A”.

I want to create formula which allows company “A” to set such price for product Cans, which will force the company “B” to lower the price of Oil for company “A” but will allow him to be profitable.

For example:
P= X*5% = 7$*5%=0.35$
Where:
P is Can price
X is oil price for company “A”


Can you help please to develop most suitable formula?

 

[monluigi]

Nobody wants to train brain?

 

[Steven G]

Nobody wants to read the forum's posting guidelines