PC Review


Reply
Thread Tools Rating: Thread Rating: 1 votes, 5.00 average.

How can I calculate selling price from cost and GP?

 
 
Bernard Liengme
Guest
Posts: n/a
 
      4th Nov 2008
No and it you asked him for "a pint" he would serve you beer without you
mentioning it!
Look at his equation - it obviously a ratio calculation.
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Gordon" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> "Bernard Liengme" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> His formula amounts to (Sell price - Cost price)/Sell price
>> So it is the percentage of the Selling price that is profit, I would
>> think
>> But then I'm a chemist
>> best wishes

>
> The OP didn't mention GP PERCENT.........



 
Reply With Quote
 
 
 
 
New Member
DonMiguel's Avatar
Join Date: Feb 2012
Posts: 1
 
      10th Feb 2012
MONTHLY FINANCIAL FORMULA:

Target SP (selling price) = VC(viariable cost) + FC(fix cost)

Example:

IF: VC is (includes the Staff Salary, labour, electric, water, gas, venture Food & Beverages)


SP = VC ($100,000) + FC (RENT-$20,000, OWN SALARY-$20,000, TAX-$5,000)

SP = $100,000 + $45,000

Selling Price = $145,000 / MO.


To Get the TARGET Daily GPA(Gross Profit Ave.) :

GP = SP / (No. of Days / Mo.)

GP = $145 / 30 Days

Target GP = $4.83 / Day


* Now make a feasibility study on how you can reach your Daily GP Target.
Do you need to adjust on your EXPENSES?
Do you need to get NEW COMPETITIVE IDEAS to increase your MARKET?

Goodluck Focus, Be Resourceful, Get Ideas, Study, Act Act and Act,
Set & Accomplish your GOALS Everyday ! Make your DREAM a Reality!


-Don Miguel Zobel de Ayala
Successful Business Man (Net Profit 2Million / Year)
20% of my income goes for the Church, Poor and Less fortunate.

Last edited by DonMiguel; 10th Feb 2012 at 02:56 PM.. Reason: wrong
 
Reply With Quote
 
New Member
Join Date: May 2012
Posts: 1
 
      2 Weeks Ago
I think the formula you need is:
Cost/(1-GP%)=Sell
EG. Cost $2, GP 25%.
$2/(1-0.25)=$2.6666
or
$2/0.75=$2.6666 (a 25%GP)
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula to determine selling price with cost known @ X margin? =?Utf-8?B?cmcy?= Microsoft Excel Worksheet Functions 3 28th Jul 2007 01:16 AM
Calculate the percentage from the cost and recommended sell price =?Utf-8?B?Sm9obg==?= Microsoft Excel New Users 5 26th Feb 2006 03:07 AM
calculate/convert volume price to monthly average price =?Utf-8?B?QnVsdGdyZW4=?= Microsoft Excel Worksheet Functions 2 14th Feb 2006 09:36 AM
looking for latest selling price.. =?Utf-8?B?TGF3cmVuY2U=?= Microsoft Excel Worksheet Functions 4 12th Nov 2005 04:49 PM
LOOK FOR LATEST SELLING PRICE =?Utf-8?B?TGF3cmVuY2U=?= Microsoft Excel Worksheet Functions 8 5th Oct 2005 10:27 AM


Features
 

Advertising
 

Newsgroups
 


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