I would like a formula that will solv for the missing variable when
calculating margin.

price cost and margin

I would like to calculate margin given price and cost, but I would also like
to come up with a price if I only hve cost and desired margin all with in the
same formula.

Can you help me.

Well, margin is purely % difference from cost to price, so...

for price =cost*1+margin where margin is an actual % .2,.5, etc.

margin would be =(price-cost)*cost

So, if price is $1, cost is $.50, margin would be 100%

Make sense? Or are you going for somethign else?

"baseballguy" wrote:

I would like a formula that will solv for the missing variable when
calculating margin.

price cost and margin

I would like to calculate margin given price and cost, but I would also like
to come up with a price if I only hve cost and desired margin all with in the
same formula.

Can you help me.

Margin = Profit / Price
or, Margin = (Price - Cost) / Price

Markup = Profit / Cost
or, Margin = (Price - Cost) / Price

Margin shows what percentage of the Price is Profit. So a 30% margin means
that 30% of the price is profit. For example, selling price = $100, cost =
$70

Markup shows how much you are increasing the cost by to get the selling
price. A 30% markup on a $70 item gives a price of $91.

If the price is $1.00, and the cost is $0.50, the margin is 50% and the
markup is 100%.

Regards,
Fred


"Sean Timmons" wrote in message
...
Well, margin is purely % difference from cost to price, so...

for price =cost*1+margin where margin is an actual % .2,.5, etc.

margin would be =(price-cost)*cost

So, if price is $1, cost is $.50, margin would be 100%

Make sense? Or are you going for somethign else?

"baseballguy" wrote:

I would like a formula that will solv for the missing variable when
calculating margin.

price cost and margin

I would like to calculate margin given price and cost, but I would also
like
to come up with a price if I only hve cost and desired margin all with in
the
same formula.

Can you help me.