Increase Percentage / Margin by 5% - Logic

[coolguykets1]

I think this is really simple but I was unable to build a logic around it.

So I have 2 Values.
A1: Cost : $ 20
B1: Current Margin : -20.84%
C1:Expected Cost : So I should have a formulae in C1 to give me expected cost($16.83) in such a way that we will make +5% in margins.

So in this case C1 should have Value($16.83) Such that New Margins in D1 would be +5%.

 

[shg]

Re: Brain Twister : Increase Percentage / Margin by 5% - Logic

If your cost is $20.00, and your margin is -20.84%, then the current sell price must be $20/(1--20.84%) ~ $16.55.

Where do you want to go from there?

 

[jamcall]

Re: Brain Twister : Increase Percentage / Margin by 5% - Logic

In C1:
=(B1+D1)*A1+A1

D1 is the amount that you want to adjust your current margin by (+5%)

HTH,
~ Jim

 

[coolguykets1]

Re: Brain Twister : Increase Percentage / Margin by 5% - Logic

Thanks for the Help. Not Working Guys.

So here is the situation.

I have a product whose current cost is $22.70. With this I am making -20.84%. However I want to assign a target cost to my team of +5% Margin always. For that my should be $17.11

So I want to create a formulae where if I have negative margins or margins lower than 5%, it should automatically calculate a target cost where I will get 5% margin

A1 B1 C1 D1
$22.70 -20.84% 5%


I want an entry in D1 which will give me 5% Margin.

FYI: My SP is $17.97 ( Fixed )

 

[jtakw]

Re: Brain Twister : Increase Percentage / Margin by 5% - Logic

Not sure if this is what you're looking for or need.

Assuming:
A1 = Current Cost
B1 = Current Margin
C1 = Expected Cost (or Target Cost)
D1 = 5% (or Target Margin)
E1 = Your Sale Price (SP), which is fixed and known.

in C1, use:
=IF(E1/A1<1.05,(E1/1.05),A1)

in D1, use:
=((E1-C1)/C1)*100

Ignore the *100 in the D1 formula if you have the Cell formatted as percentage.

Let us know if this is what you're looking for.

 

[coolguykets1]

Re: Brain Twister : Increase Percentage / Margin by 5% - Logic

Hi,
Thanks This is exactly what I was looking for.
Appreciate the help

 

[jtakw]

Re: Brain Twister : Increase Percentage / Margin by 5% - Logic

You're welcome, glad to help. A vote of "Like" would be nice.

 

[Joe4]

Re: Brain Twister : Increase Percentage / Margin by 5% - Logic

A vote of "Like" would be nice.

They actually don't mean very much here (you cannot easily tell who gave you new likes).

We actually recommend that users reply back with replies, like coolguykets1 did in post #6. Seems a little more personal too!