LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.newusers
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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to determine selling price with cost known @ X margin? rg2 Excel Worksheet Functions 3 July 28th 07 01:16 AM
Calculate the percentage from the cost and recommended sell price John New Users to Excel 5 February 26th 06 03:07 AM
find selling price of bonds charlene Excel Worksheet Functions 2 December 19th 05 03:30 AM
looking for latest selling price.. Lawrence Excel Worksheet Functions 4 November 12th 05 04:49 PM
LOOK FOR LATEST SELLING PRICE Lawrence Excel Worksheet Functions 8 October 5th 05 10:27 AM


All times are GMT +1. The time now is 03:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"