[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 766
  • Last Modified:

Strange one - Algebra!

Hi, on a spreadsheet i want to work out the missing variable

I know the desired Gross Profit = .65
I know the Cost of Sale = 1.306

How can i derive the sales price using a formula on excel?

Thanks
Seamus
0
Seamus2626
Asked:
Seamus2626
1 Solution
 
Julian HansenCommented:
Is the GP a percentage or an actual amount

SP = CoS + Profit

or

SP = CoS * (1 + ProfitPercentage)
0
 
Elton PascuaCommented:
On another note, if this is something you will do regularly and in different scenarios, look into "Goal Seek".

http://www.homeandlearn.co.uk/excel2007/excel2007s7p4.html

Open in new window

http://office.microsoft.com/en-us/excel-help/about-goal-seek-HP005203894.aspx

Open in new window

0
 
TommySzalapskiCommented:
If gross profit is just 65 cents, then add them.
If it is a percentage, then do you mean you want 65% of the sale price to be profit?

GPP = Gross Profit Percent
SP = Sale Price
CS = Cost of sale

So CS/SP = 1 - GPP

or SP = CS/(1 - GPP)

julianH, in your formula, CoS is 65% greater than SP but the actual percent profit would only be 65/165 or about 39%
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
TommySzalapskiCommented:
And I don't think you need Goal Seek for this. Just plug that formula into the spreadsheet.
0
 
Seamus2626Author Commented:
This is what i was looking for.

Thanks for everyones input

Seamus
0
 
Julian HansenCommented:
@TommySzalapski I was going on the assumption he wanted to make a gross profit of 65%
0
 
TommySzalapskiCommented:
Using your formula
SP = CoS * (1 + ProfitPercentage)
SP = 1.306*(1.65) = 2.1549
65% of 2.1549 is about 1.4 but profit is only 2.1549 - 1.306 = 0.8489
When the term Gross Profit is used, it generally refers to the percent of the price, not the percent of the cost.
If he wants a 65% markup, then your formula is the way to go.
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now