You want to calculate Profit Margin or Price Markup? Fair Game.
I’ve put the explanations and an Excel template in the post. It’s detailed but you need to be able to read mathematical notation and have some understanding of business terms.
I’ll try and explain some of the concepts and cover Selling Price, Mark-up Percentage, Gross Margin Percentage, and Selling Price Margin which are the sales formulas for businesses.
I might go into the net, gross, and cost of goods. As we go along we’ll make mention of price-points and other marketing terminology.
This isn’t the only Business Ratio out there, for the full bang check out the book
Introduction to the uninitiated
Regardless of the business, managers and owners of a business have a language all their own, that’s called a vernacular. The terms and phrases convey concepts that are critical to the running and managing of the business without needing to explain it each time it is being talked to. Examples of this are net, gross, cost of goods, markup, markdown, the margin. Learn them, love them and know what they refer to.A little off track, just as Management has a language, so does every other profession, if you are in sales, you would need to know the sales terms like a green field, low hanging fruit, bluebird, closed questions, gatekeeper, decision maker, and sandbagging.
Skipping to the end
Some of you are only here for the Excel sheet, here you are freeloaders Excel template for Markup and Profit Margin.
Some Definitions if you need them
This paragraph isn’t detailed try this book Business Maths here. Gross refers to the total (everything) and net refers to the part of the total that really matters (what you take home, or were left with). The revenue is what you make (income) from sales, minus discounts and rebates via the main operations of the business. Finally, the cost of goods sold (abbreviated COGS) is a combined value that takes into account numerous out-going money streams such as all the costs of purchase, transport, packaging, material, labour, allocated overhead to store (this is oversimplification it also uses LIFO or FIFO). The goods not sold is deferred as a cost of inventory until the inventory sells or gets written down in value.
We need to go through a very simplistic explanation of pricing. In retail psychological pricing is a strategy that says consumers assume odd or un-rounded prices are perceived lower than they actually are. An Example of this would be $ 1.99 or $ 1.98 is perceived as $ 1.00 and not $ 2.00. An easy-ish (I suppose) rounding mistake, unless you are talking about $ 49,999 and the rounding mistakes is $1,000. If you suffer from this mental tick, just practice always rounding up. Psychological pricing is one type of strategy that you can follow. Others are price skimming, price discrimination and yield management, price points, bundle pricing, penetration pricing, price lining, value-based pricing, geo and premium pricing all of which are demand-driven strategies.
For my calculation examples, I am going to use a psychological selling price of $1.99
My cost price/purchase price/buy price is going to be $ 1.40
If we know our cost, and selling price, and we want to know the mark-up percentage.
If we don’t have the selling price, but we know the selling price and have a 42% mark up:For this step, we need to keep in mind that 42% can also be written as 0.42.
Gross Margin Percent
Changing the Mark-up Percentage calculation slightly to the Gross Margin Percent calculation:
Selling Price Margin
If you have a margin requirement of 30% and need to apply this to your pricing:
We’ve gone through the basic pricing calculations for Markup and Margin and looked at both cost + markup/margin and cost and selling to calculate markup/margin perspectives.
Here is an Excel template for Markup and Profit Margin to see the calculations. Click on the link.
If you want to learn more about Business Maths here is a great book on the subject.