Calculating % GP anyone??

Hey guys,

Basically im running a new bar in Leeds and im trying to create a spreadsheet which will tell me how much to charge per drink to gain a 80% GP on products, ive got as far as listing the products and prices and calculating how much every measure (25ml) will cost. In the past ive used formulas where I can input the price i charge and it will calculate the GP (=SUM(D10/E10)*100-100) for example but id like to be able to type in the GP I want and for it to tell me the price i need, im not sure if tis possible but it will be a massive time saver and i hope one of you experts can help me out!!

Thanks in advance guys!!

Simon

I dont think thats right, this calculates an 80% mark up which would be useless as a drink costing you 50p to make, this formula tells you to sell for 90p. An 80% GP on a drink costing 50p is £2.50

isn't that a 400% mark up? anyhow just change to =A2+(A2*4)

Yeah that seems to work, is there an easy way to change that, for example obviously food and wine have a differant gross profit margins than beer and spirits, is there a way to calculate how to acheive any percentage from 70 - 90%?

Well basically...

The Gross Profit is the difference between the selling price and the cost price (income - expense)

To calculate the Gross Profit, the cost price is simply subtracted from the selling price.

This amount as a percentage of the selling price (excl sales tax) gives you the GP%.

For Example: If a drink is costed at 0.50p and sold at £2.50 you would subtract the cost price from the sell price to get the Gross Profit: £2.50 - 0.50 = £2.00

To calculate the GP% all you do is (2.00 / 2.50) * 100 = 80%

Simon

Understand two formulas:
Gross Profit Percent = 1 - (Cost / Price).
Price = Cost / (1 - GP%)

(algerbra will confirm this).

So to get price when Cost is known and GP% is known use the formula on the attached worksheet for price.

Hi


With the level of Gross Profit expressed as a % in cell A1, e.g 45%

Cost price for each Product in B2 downward,

then enter in C2
=B2/(1-$A$1)

should do it

Thats exactly what im looking for, ideal bro nice one!!! Had to quickly change it into £ signs tho!!

Thanks for this guys.

I know this is an old thread but that's the wonders of Google.

I had a GP function on the calculator I had at my old job and I don't at my new job so I wanted to set one up on my desktop.

I've just taken that formula and adapted it to what I want to do.

Cheers

Hi,

I am new here, but I came across this forum as I am trying to achieve the same thing. I know it's an old thread , but hopefully somebody would be able to supply a working copy of the document.

Kindest Regards,
Wyzo