Stevo985 Posted May 19, 2010 VT Supporter Share Posted May 19, 2010 Quick maths question if I may? I have Cost Price (X) & Selling Price (Y) of an item and I want to get % Margin. How do I do so in a formula? Apologies if this makes me sound really thick... EDIT: Is it? (Cost-Sale)/(Cost)*100 Margin is percentage of selling price that is profit. Mark up is percentage of cost that you add on to get a selling price. So in your case, Margin = ((Y-X)/Y)*100 i.e. sale price minus cost (to get profit), divided by sale price to get a percentage. Link to comment Share on other sites More sharing options...
Stevo985 Posted May 19, 2010 VT Supporter Share Posted May 19, 2010 Quick maths question if I may? I have Cost Price (X) & Selling Price (Y) of an item and I want to get % Margin. How do I do so in a formula? Apologies if this makes me sound really thick... ((S/C)*100)-100 gives you the margin Nope, that gives you the mark-up, not the margin. Link to comment Share on other sites More sharing options...
AVFCLaura Posted May 19, 2010 Author Share Posted May 19, 2010 Quick maths question if I may? I have Cost Price (X) & Selling Price (Y) of an item and I want to get % Margin. How do I do so in a formula? Apologies if this makes me sound really thick... EDIT: Is it? (Cost-Sale)/(Cost)*100 Margin is percentage of selling price that is profit. Mark up is percentage of cost that you add on to get a selling price. So in your case, Margin = ((Y-X)/Y)*100 i.e. sale price minus cost (to get profit), divided by sale price to get a percentage. Yes, I jotted them down the wrong way. So (Sale-Cost)/Sale*100 Brilliant, thanks Poindexter. Link to comment Share on other sites More sharing options...
BOF Posted May 19, 2010 Moderator Share Posted May 19, 2010 Quick maths question if I may? I have Cost Price (X) & Selling Price (Y) of an item and I want to get % Margin. How do I do so in a formula? Apologies if this makes me sound really thick... ((S/C)*100)-100 gives you the margin Nope, that gives you the mark-up, not the margin. Oh fiddlesticks Link to comment Share on other sites More sharing options...
claret75 Posted May 19, 2010 Share Posted May 19, 2010 I feel compelled to watch the end One of the shittest films ive seen lately is Drag Me To Hell, not sure whether it was supposed to make me laugh as much as i was :S Link to comment Share on other sites More sharing options...
Stevo985 Posted May 19, 2010 VT Supporter Share Posted May 19, 2010 Quick maths question if I may? I have Cost Price (X) & Selling Price (Y) of an item and I want to get % Margin. How do I do so in a formula? Apologies if this makes me sound really thick... ((S/C)*100)-100 gives you the margin Nope, that gives you the mark-up, not the margin. Oh fiddlesticks "Ask BOF Anything" Yeh right. Link to comment Share on other sites More sharing options...
Anthony Posted May 19, 2010 VT Supporter Share Posted May 19, 2010 Sure, you can ask him anything... Link to comment Share on other sites More sharing options...
AVFCLaura Posted May 19, 2010 Author Share Posted May 19, 2010 And I can use the term 'Gross Profit %' to be a description of that? I am doing a huge project for the son of the owner of the company I work for, so just want to make sure everything is spot on. Link to comment Share on other sites More sharing options...
YLN Posted May 19, 2010 Share Posted May 19, 2010 Anyone know how to do least square regression lines? Link to comment Share on other sites More sharing options...
Stevo985 Posted May 19, 2010 VT Supporter Share Posted May 19, 2010 And I can use the term 'Gross Profit %' to be a description of that? I am doing a huge project for the son of the owner of the company I work for, so just want to make sure everything is spot on. Yes, sort of. Gross Profit Margin is (Total sales - Total cost of Sales) / Total Sales *100 So if everything costs the same sells for the same price then you can multiply your profit margin (per unit) by total units sold to get GPM. But if everythin costs different amounts and sells for different prices, you need to do the formula above. Link to comment Share on other sites More sharing options...
BOF Posted May 19, 2010 Moderator Share Posted May 19, 2010 "Ask BOF Anything" Yeh right. Pah, mark-up, margin, tomayto, tomahto. Link to comment Share on other sites More sharing options...
wiganvillain Posted May 19, 2010 Share Posted May 19, 2010 Damn and blast, Finally get a subject I can expound on and a bloody accountant gets in first on a commercial subject BOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOO Link to comment Share on other sites More sharing options...
Stevo985 Posted May 19, 2010 VT Supporter Share Posted May 19, 2010 Accountants FTW! Being on VT when I should be accounting....also FTW! Link to comment Share on other sites More sharing options...
ED Posted May 19, 2010 Share Posted May 19, 2010 CODA FTW! Link to comment Share on other sites More sharing options...
bcarpet Posted May 19, 2010 Share Posted May 19, 2010 I feel compelled to watch the end One of the shittest films ive seen lately is Drag Me To Hell, not sure whether it was supposed to make me laugh as much as i was :S I found that too! it was awful, me and the missus nearly walked out of it. what was the deal with that guy dancing in mid air?! Link to comment Share on other sites More sharing options...
AVFC-Prideofbrum Posted May 19, 2010 Share Posted May 19, 2010 Stevo with some big knowledge. Do my business exam for me. Please...please, they won't know. Link to comment Share on other sites More sharing options...
mjmooney Posted May 19, 2010 VT Supporter Share Posted May 19, 2010 All these accountancy hard sums are making my head hurt. Total blind spot with me, don't understand one iota of it. Link to comment Share on other sites More sharing options...
AVFCLaura Posted May 19, 2010 Author Share Posted May 19, 2010 And I can use the term 'Gross Profit %' to be a description of that? I am doing a huge project for the son of the owner of the company I work for, so just want to make sure everything is spot on. Yes, sort of. Gross Profit Margin is (Total sales - Total cost of Sales) / Total Sales *100 So if everything costs the same sells for the same price then you can multiply your profit margin (per unit) by total units sold to get GPM. But if everythin costs different amounts and sells for different prices, you need to do the formula above. Best to call it % margin then? As I have no sales information, just cost and sale price analysis. Link to comment Share on other sites More sharing options...
AVFC-Prideofbrum Posted May 19, 2010 Share Posted May 19, 2010 Happy Birthday for last Sunday Laura Link to comment Share on other sites More sharing options...
CarewsEyebrowDesigner Posted May 19, 2010 Share Posted May 19, 2010 I'd hate to work with numbers. I enjoyed maths, it was fun. But it'd make me feel old as ****. Link to comment Share on other sites More sharing options...
Recommended Posts