0
$\begingroup$

We are importing sales data from a company we just purchased. We want to calculate the logistics value so that the profit margin is 13%.

We have the following rules in our system:

Profit = SalesValue - OriginalPrice - LogisticsValue
CostValue = OriginalPrice + LogisticsValue

ProfitMargin = Profit/CostValue * 100
             = (SalesValue - OriginalPrice - LogisticsValue) / (OriginalPrice + LogisticsValue) * 100

If SalesValue = $1000, OriginalPrice = $750 and ProfitMargin = 13 and LogisitcsValue = LV then

             13 = ((1000-750-LV)/(750+LV)) * 100
                = (250 - LV) / (750+LV) * 100
0.13 * (750+LV) = (250 - LV)
    0.13LV + LV = 250

How can I find the value of LV?

3 Answers 3

0

Just worked out what I was missing.

0.13LV + LV = 1.13LV

So

0.13LV + LV = 250
     1.13LV = 250
         LV = 250/1.13
         LV = 134.96 (to 2 decimal places)
1

You have an error in your last step there. It should read:

$0.13(750+LV)=250-LV \Rightarrow 0.13(750)+0.13LV=250-LV \Rightarrow 1.13LV=250-0.13(750) \Rightarrow LV \approx 134.955$.

  • 0
    Thanks. Typo when putting it into the site. 134.96 was the answer I got2012-09-10
1

Here is a formula you can use generally.

LV = ( 100*(SV - OP) - PM*OP )/ (100 + PM)

In your example, you would get 134.96.