View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default How can I calculate selling price from cost and GP?

Rearranging GP = 1-(cost price/selling price) gives
selling price = cost price /(1- GP)
The word 'maths' suggests UK - I got my 'O' level math in 1954!
So please check this with some data
I wonder if I ever visited your Tilbury pub
best wishes from Canada
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Tilburyboozer" wrote in message
...
We have a pub, and we really need to keep a close watch on profit margins.
I
have a formula for calculating the GP from nett cost and selling prices [
which is 1-(cost price/sales price) ] but my maths lessons are nearly 50
years back, and I can't work out how to calculate the price we need to
charge
in order to make the right margins.

A younger memory will solve this in seconds, I know, so please lend a
hand.