Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mark up and Margin
I need a formula to produce a selling price when cost is known and desired
gross margin (on sales) is an input variable. For example, cost equal $60, desired gross margin (percent) equals 40; the result would be $100 Can you help a rookie? |
#2
|
|||
|
|||
A1 is cost price B1 is percentage markup entered as a % i.e. 40% or as a general number 0.4 enter in C1 =A1/(1-B1) -- Greetings from New Zealand Bill K "sdmccabe" wrote in message ... I need a formula to produce a selling price when cost is known and desired gross margin (on sales) is an input variable. For example, cost equal $60, desired gross margin (percent) equals 40; the result would be $100 Can you help a rookie? |
#3
|
|||
|
|||
Perfect Bill K - thanks!
"Bill Kuunders" wrote: A1 is cost price B1 is percentage markup entered as a % i.e. 40% or as a general number 0.4 enter in C1 =A1/(1-B1) -- Greetings from New Zealand Bill K "sdmccabe" wrote in message ... I need a formula to produce a selling price when cost is known and desired gross margin (on sales) is an input variable. For example, cost equal $60, desired gross margin (percent) equals 40; the result would be $100 Can you help a rookie? |
#4
|
|||
|
|||
Cost = $60
Margin is 40% Result would be $84 in my estimation. Gord Dibben Excel MVP On Sat, 2 Jul 2005 16:14:01 -0700, "sdmccabe" wrote: I need a formula to produce a selling price when cost is known and desired gross margin (on sales) is an input variable. For example, cost equal $60, desired gross margin (percent) equals 40; the result would be $100 Can you help a rookie? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To make a margin | Excel Discussion (Misc queries) | |||
print excel truncated on left margin | Excel Discussion (Misc queries) | |||
gross profit margin formula | Excel Discussion (Misc queries) | |||
Can one have an extra margin gutter, for binding a document print. | Excel Discussion (Misc queries) | |||
how do I make the left margin of a header the same as the page ma. | Excel Discussion (Misc queries) |