Thank you Nander. This is exactly what I was looking for - Margin not markup.
It worked perfectly for me in my quoting.
--
Therese
"nander" wrote:
Just a note to keep in mind that Markup is not the same thing as Margin.
You might want to switch from thinking about markup to margin. On your
Income statement Margin is what covers the expenses to get your profit
NOT markup. When I compute my prices I have a cost column a gross
margin column and a price column.
If something costs you $1.00 and you sell it for $4.00
The gross margin is (4.00-1.00)/4.00 = 75%
So if in Cell A1 has $1.00
B1 has .75 or what ever Gross margin you want to
make
the price calculation for this item would be in cell C1 would be
A1/(1-B1)=1.00/(1-.75)=4.00
--
nander
------------------------------------------------------------------------
nander's Profile: http://www.excelforum.com/member.php...fo&userid=6156
View this thread: http://www.excelforum.com/showthread...hreadid=397123