How to calculate a markup on a product to avoid going into the red
Correctly calculating markup is the foundation of a profitable business. Too low a markup will lead to losses, while too high a markup will lead to a loss of competitiveness. In this article, you'll learn how to mathematically accurately calculate the optimal markup for a product, taking into account all costs, the difference between markup and margin, and how to avoid common pricing mistakes.
What is a markup and margin: what is the difference?
Many entrepreneurs confuse markup and margin, but these are different indicators that are calculated differently and have different meanings for analyzing business profitability.
Markup
Markup — is a percentage added to the product's cost price to determine the final selling price. The markup indicates how much higher the selling price is than the purchase price.
Markup = ((€75 - €50) / €50) × 100% = 50%
Margin
Margin — is the percentage of profit from the final selling price. Margin shows what percentage of the price your profit represents.
Margin = ((75€ - 50€) / 75€) × 100% = 33.33%
Comparison table
| Parameter | Markup | Margin |
|---|---|---|
| Calculation base | Cost of goods | Selling price |
| Formula | (Price - Cost) / Cost. | (Price - Cost) / Price |
| Maximum value | Unlimited (can be >100%) | Up to 100% |
| What is it used for? | Price formation | Profitability analysis |
| Example (50€ → 75€) | 50% | 33.33% |
Important: The markup is always greater than the margin at the same price. The markup can exceed 100%, but the margin never does.
Markup calculation formulas
Basic formula for calculating markup
Selling price = 100€ × (1 + 40 / 100) = 100€ × 1.4 = 140€
Calculation of markup taking into account VAT
In European countries, VAT ranges from 17% to 27%. It's important to understand that VAT is not your profit, but a tax you collect for the state.
Cost price: 100€
Markup: 50%
Price without VAT: 100€ × 1.5 = 150€
Price with VAT: 150€ × 1.19 = 178.50€
Calculating the required markup to achieve target profit
Cost price: 100€
Operating costs per unit: 20€
Desired profit: 30€
Required markup = ((100 + 20 + 30) / 100 - 1) × 100% = 50%
Reverse calculation: from the selling price to the markup
Maximum markup = ((200 / 130) - 1) × 100% = 53.85%
Factors Affecting the Markup Amount
1. Product type
Mass-produced goods: 10-30% (food, basic goods)
Specialized: 50-100% (electronics, clothing)
Premium segment: 100-300% (luxury, exclusive)
2. Competition
High competition reduces potential markups by 20-40%. Unique products allow for a 50-150% increase in markup.
3. Operating expenses
Rent, salaries, logistics, marketing, taxes—everything must be covered by a markup, usually 15-35% of the price.
4. Turnover
Fast-selling products may have a lower markup (20-40%), while slow-selling products require a higher markup (60-150%).
5. Seasonality
During peak season, the markup may be 30-70% higher; during low season, price reductions or sales are required.
6. Brand and positioning
A strong brand allows you to add 50-200% to the standard markup due to perceived value.
Practical examples of markup calculations
Example 1: Online electronics store
Initial data:
- Laptop purchase price: €450
- Delivery from supplier: 15€
- Operating costs (per unit): €35
- Desired profit: 80€
- VAT: 19% (Germany)
Calculation:
- Total cost: €450 + €15 + €35 = €500
- Price without VAT: 500€ + 80€ = 580€
- Markup: ((580 - 450) / 450) × 100% = 28.89%
- Price with VAT: €580 x 1.19 = €690.20
Total: At a retail price of €690.20, you get €80 net profit after all costs are taken into account.
Example 2: Clothing store
Initial data:
- Purchase price of the dress: 30€
- Customs and shipping: €5
- Rent (per unit with a turnover of 100 units/month): €3
- Staff salary (per unit): €4
- Marketing: 2€
- Target margin: 40%
- VAT: 20% (France)
Calculation:
- Total cost: 30 + 5 + 3 + 4 + 2 = 44€
- For a 40% margin: Price = Cost / (1 - Margin) = 44 / 0.6 = €73.33
- Markup: ((73.33 - 30) / 30) × 100% = 144.43%
- Price with VAT: €73.33 x 1.20 = €88
Total: The retail price of €88 provides a 40% margin and covers all costs.
Markup Calculator: A Step-by-Step Example
Let's consider the calculation for a product taking into account all factors:
Results:
- Purchase price markup: 60%
- Margin from selling price: 37.5%
- Net profit: 30€ (18.75% of the price without VAT)
Comparative table of markups by industry
| Industry | Typical markup | Typical margin | Example |
|---|---|---|---|
| Food products | 15-30% | 13-23% | Buy 2€ → Sell 2.60€ |
| Electronics | 20-40% | 17-29% | Purchase 500€ → Sale 700€ |
| Cloth | 100-200% | 50-67% | Purchase 30€ → Sale 90€ |
| Furniture | 50-80% | 33-44% | Purchase €300 → Sale €540 |
| Cosmetics | 80-150% | 44-60% | Buy 20€ → Sell 50€ |
| Jewelry | 200-400% | 67-80% | Purchase 100€ → Sale 500€ |
Taking into account all costs when calculating the markup
Many aspiring entrepreneurs consider only the purchase price of goods, forgetting about a host of other expenses. This is a surefire way to lose money.
The full list of costs that the markup must cover:
1. Direct costs of goods
- Purchase price — the cost of the goods from the supplier
- Delivery from the supplier — transportation, cargo insurance
- Customs duties - when imported from outside the EU (0-17%)
- Package - branded packaging, protective materials
- Marking - labels, tags, barcodes
2. Operating expenses
- Renting premises - warehouse, store, office (distributed by goods)
- Staff salaries - salespeople, managers, warehouse workers
- Public utilities - electricity, internet, heating
- Storage - warehouse costs, climate control
- Packaging for delivery - boxes, bags, fillers
3. Marketing and sales
- Advertising — Google Ads, Facebook, Instagram (usually 5-15% of the price)
- Marketplace commission — Amazon (8-15%), eBay (10-12%)
- Payment systems — 1.5-3% of the transaction amount
- Product photography — professional photos for the catalog
- Content — descriptions, videos, infographics
4. Returns and losses
- Customer returns — 2-10% depending on the category
- Defects and damages — 1-5% of the goods may be damaged
- Thefts — for offline stores 0.5-2%
- Illiquid asset - goods that failed to sell
5. Financial expenses
- Loans and credits - interest on procurement financing
- Banking services - current account, transfers
- Accounting - accounting, reporting
- Taxes — VAT, income tax (accounted for separately)
An example of a full calculation taking into account all costs
Product: Smartphone in the online store
| Expense item | Amount, € | % of the purchase price |
|---|---|---|
| Purchase price | 400.00 | 100% |
| Delivery from the supplier | 12:00 | 3% |
| Packaging and labeling | 3.00 | 0.75% |
| Warehouse rental (per unit) | 5.00 | 1.25% |
| Salary (order processing) | 8.00 | 2% |
| Advertising (with a 2% conversion rate) | 25.00 | 6.25% |
| Marketplace commission (10%) | 50.00 | 12.5% |
| Payment systems (2%) | 10.00 | 2.5% |
| Delivery to the buyer | 6.00 | 1.5% |
| Returns and defective items (5% reserve) | 25.00 | 6.25% |
| Other expenses | 6.00 | 1.5% |
| TOTAL COST | 550.00 | 137.5% |
| Desired profit | 50.00 | 12.5% |
| PRICE WITHOUT VAT | 600.00 | 150% |
| VAT 19% | 114.00 | 28.5% |
| FINAL PRICE | 714.00 | 178.5% |
Conclusions from the calculation:
- Purchase price markup: 50% (200€ / 400€)
- Real profit: 50€ or 8.3% from retail price
- If we only took into account the purchase price (400€) and added a 30% markup, we would get a price of 520€ + VAT = 619€
- At a price of 619€ instead of 714€ — 50€ loss on each sale!
Common mistakes when calculating markups
Mistake 1: Accounting only for the purchase price
The most common mistake is to add a markup only to the purchase price of the product, ignoring all other costs.
Consequences: Every sale brings a loss, the business operates at a loss.
Solution: Calculate the total cost, including all operating expenses, and add the markup to that amount.
Mistake 2: Confusion between markup and margin
An entrepreneur hears that in his industry the "standard margin is 40%," applies 40% as a markup, and ends up with a real margin of 28.6%.
Consequences: Loss of profit, inability to cover expenses.
Solution: Clearly distinguish between the concepts. If you need a 40% margin, use the formula: Price = Cost / (1 - 0.4)
Mistake 3: Ignoring VAT
Calculation of price excluding VAT or inclusion of VAT in profit.
Consequences: By understating the price by 17-27% (depending on the VAT rate), the real margin turns out to be negative.
Solution: Always calculate the markup on the price without VAT, and then add VAT on top.
Mistake 4: Same markup on all products
Applying a fixed percentage markup to all products without taking into account their specific features.
Consequences: Some products are overpriced and have no sales, while others are unprofitable.
Solution: Differentiate the markup depending on turnover, competition, and product category.
Mistake 5: Forgetting about returns and defective products
Do not include the percentage of returns, defective goods, and illiquid items in the markup.
Consequences: When 10% of goods are returned, the real profit is eaten up.
Solution: Allow a 3-10% reserve for returns depending on the category. For clothing, allow 10%, for electronics, 5%, and for food, 2%.
Mistake 6: Not taking marketplace fees into account
Setting a price without taking into account that the marketplace will take an 8-15% commission.
Consequences: Reducing the margin by the amount of the commission, often to zero or negative values.
Solution: Include the platform's commission in the cost price or increase the price accordingly.
Mistake 7: Copying Competitors' Prices
Setting a price "like the competitor" without analyzing your own cost structure.
Consequences: A competitor may have different production costs and expenses—blind copying leads to losses.
Solution: Analyze the market, but set your price based on YOUR costs and desired profit.
Mistake 8: Not revising the markup
Set the markup once and do not adjust it when conditions change.
Consequences: As expenses rise, exchange rates fluctuate, and taxes change, the markup becomes insufficient.
Solution: Review pricing at least quarterly or whenever there are significant market changes.
Automate markup management with Elbuz
The Elbuz platform automatically processes supplier price lists, calculates optimal markups based on all costs and competitive prices, helping you avoid common pricing errors.
Possibilities:
- Automatic calculation of markup taking into account all expenses
- Flexible pricing rules for different categories
- Monitoring competitors' prices
- Real-time marginality analysis
- Dynamic price adjustment
Practical tips for setting a markup
1. Start with a full cost audit
Before setting a markup, list all your business expenses for the last month. Divide them by the number of items sold to get your average cost per unit.
2. Calculate the break-even point
Minimum markup = (Total fixed costs / Planned sales quantity + Variable costs per unit) / Purchase price x 100%
Anything below this markup is a loss.
3. Use differentiated pricing
- Locomotive products: minimum markup of 15-25% to attract customers
- Popular products: average markup 35-50%
- Related products: increased markup of 60-100%
- Exclusive products: maximum markup 100-300%
4. Test different price levels
Don't be afraid to experiment. A/B testing of pricing may show that a 10-15% price increase doesn't reduce sales but significantly increases profits.
5. Consider the psychology of pricing
- Prices ending in 9 or 99 (€19.99 instead of €20) - work for bulk items
- Round numbers (€50, €100) are better for the premium segment
- Comparison with a more expensive product makes the average price attractive
6. Monitor your competitors, but don't copy blindly
Monitor your competitors' prices, but remember: your cost structure may be different. If your cost is higher, either optimize your expenses or find ways to justify the higher price (service, warranties, speed).
7. Implement an automatic calculation system
Manually calculating markups for thousands of products is inefficient. Use Excel formulas or specialized software for automated pricing.
Formula for Excel/Google Sheets
Cells:
- A2 — Purchase price
- B2 — Delivery
- C2 - Operating costs per unit
- D2 — Desired profit in %
- E2 — VAT rate in %
Formula for the final price with VAT:
Formula for markup:
Conclusion
Calculating a proper markup isn't just math; it's the foundation of a sustainable and profitable business. Key takeaways from this article:
- Consider ALL costs — not only the purchase price, but also delivery, operating costs, marketing, returns, and platform commissions.
- Distinguish between markup and margin These are different indicators that are calculated differently. Markup is added to the cost price, while margin is calculated based on the selling price.
- VAT is not your profit — Always calculate the markup on the price without VAT, and then add the tax on top.
- Differentiate your markup — different products require different markups depending on turnover, competition, and category.
- Review prices regularly — The market changes, costs rise, and exchange rates fluctuate. Review your pricing at least quarterly.
- Automate the process Manually calculating markups for hundreds or thousands of products is ineffective. Use specialized tools.
- Test and optimize Don't be afraid to experiment with markup levels. Sometimes a small price increase doesn't impact sales but significantly increases profits.
Remember: the goal of business is not maximum sales, but maximum profit. A markup that's too low will result in you working hard but earning little. The right markup strikes a balance between competitiveness and profitability.
Start calculating the full cost of your product right now. - and you will be surprised how different the real picture is from the one you imagined.
- What is a markup and margin: what is the difference?
- Markup calculation formulas
- Factors Affecting the Markup Amount
- Practical examples of markup calculations
- Taking into account all costs when calculating the markup
- Common mistakes when calculating markups
- Practical tips for setting a markup
- Conclusion
Save a link to this article
I unravel the secrets of successful online store automation, plunging into the world of effective solutions and secrets of online business - welcome to my virtual labyrinth, where every line is the key to automated success!
Discussion of the topic – How to calculate a markup on a product to avoid going into the red
How to calculate a markup on a product to avoid going into the red
There are no reviews for this product.
Write a comment
Your email address will not be published. Required fields are checked *