(a)Price per ton ($) $200.00
(b)Purchased Quantity (tons) 150.00000
(c)Mid Exchange Rate (Local Currency) 123.00000
(d)Item Ratio 55.00%
(e)Conversion to Kilogrammes 1,000.00
(f)Levy per kilogramme (local currency) 1.60
(g)Cost (local currency) 3,690,000.00
(h)Total Levy (local currency) 436,364.00
(i)Total Receipt (local currency) 4,126,364.00
I need formula(s) that should work to get 150.00 tons using total receipt of (i) 4,126,364.00.
Currently the formula is as follows:
Cost of ( which is (g)) is "ROUND((a)*(b)*(c),0)" = 3,690,000.00
Total levy (which is (h)) "ROUND((b)*(e)/(d)*(f),0)" = 436,364.00
I would like to have formula(s) so that when I enter 4,126,364.00, I should be able to get 150 tons as an answer.
With the same formula(s) I should be able to split the 4,126,364.00 into cost (g) and levy (h) using given data like shown above.
Thanks in advance.
Bookmarks