A simple Excel tool to help you with
Want to get a handle on Pricing, Markup and Margin?
Are you not sure which method to use for your pricing structures? How would they compare?
Markup and Margin are often used interchangeably.
But, they are not the same thing.
This leads to confusion when comparing suppliers.
Markup = The percentage of your cost you add to your cost to determine your price to the customer.
e.g. Cost = £10. 10% markup = £1. Price to customer = £10 + £1 = £11
Margin = The percentage difference between your cost and the price to your customer as a percentage of the price.
e.g. Cost = £10. Price to customer = £11. Margin = (11-10) / 11 = 9%
A simple-to-use, neat, Markup and Margin Excel Tool
The Simple Markup and Margin Excel Tool from Working Data:
Calculates Markup from Margin, and Margin from Markup.
Compare and Contrast the two methods.
See how different markups and margins affect your final prices.
Save yourself time by automating your Markups and Margins.
Reusable & 100% Money Back Guarantee (30 days from date of purchase)
How to use the Simple Excel Markup and Margin Tool
Know your Costs and Markup? Now Calculate Price and Margin
If you know your costs and what markup you want to apply, this is the section for you. Add your markup percentage in the top right box, then add each product’s cost and let the Excel Tool calculate your price and margin!
Know your Costs and Margin? Now Calculate Price and Markup
If you know your costs and what margin you want to apply, this is your section. Add your margin percentage then add the cost to each row and let the Excel Tool calculate your price and markup!
Know your Costs and Prices? Now Calculate Margin and Markup
If you know your costs and what prices you want to charge the third section is for you. Enter your cost and price per item and watch as the Excel Tool automatically calculates your markup and margin!
Some further information on the subject
As you can see, markup and margin are not the same.
100% markup is equivalent to 50% margin.
However, ‘markup’ and ‘margin’ are often used interchangeably. This is usually done quite innocently, but can lead to stressful confusion when trying to compare suppliers and products. The Markup & Margin Excel Tool will help you overcome this problem. You can set your pricing by markup or margin, or start with your cost and price and calculate back to your markup or margin. If one supplier is talking to you in markup and the other in margin, enter their data into the Excel Tool to compare like-for-like. Set your pricing policy and set prices accurately, quickly and simply.
How We Work
From a free consultation to ongoing support, find out the simple stages we take you through when you engage us to build your bespoke business solution.
Automate Business Processes
Software can automate many manual and time-consuming processes. Discover how processes in your business can be automated by software.
Who We Work With
Working Data have designed, built and supported bespoke business software for companies from all sectors and of all sizes.