SKU Profitability Analyzer
See how each product performs financially. This tool helps you analyze SKU‑level profitability by combining net selling price, unit cost, overhead, and volume to calculate margin percentage, profit per unit, and total profit per SKU.
SKU profitability formulas
SKU‑level profitability is one of the most practical lenses for understanding a product business. Instead of looking only at total revenue or total margin, SKU analysis zooms in on a single product: how much it sells for, how much it costs to produce and ship, how much overhead it carries, and how much profit it generates per unit and per period.
1. Net selling price per unit
Net selling price per unit =
List price per unit × (1 − Average discount % ÷ 100)
Example:
List price per unit = 79
Average discount % = 15
Net selling price per unit = 79 × (1 − 0.15) = 67.15
Net selling price reflects what customers actually pay after discounts and promotions. You can enter it directly or let the calculator derive it from list price and average discount.
2. Total unit cost
Total unit cost =
Direct unit cost
+ Shipping & packaging per unit
+ Allocated overhead per unit
Total unit cost combines direct production or purchase cost with logistics and overhead. Overhead allocation can include warehousing, marketing, or other shared costs you assign to the SKU.
3. Profit per unit
Profit per unit =
Net selling price per unit − Total unit cost
Profit per unit is the core metric for SKU profitability. If it is negative, the SKU is losing money on each sale. If it is positive but small, the SKU may still be worth keeping for strategic reasons, but it will not drive much margin.
4. Margin percentage
Margin percentage (%) =
(Profit per unit ÷ Net selling price per unit) × 100
Margin percentage shows how much of each sale is available for profit after covering unit costs. It is useful for comparing SKUs with different price points and cost structures.
5. Effective units sold and total profit
Effective units sold =
Units sold per period × (1 − Returns & allowances % ÷ 100)
Total profit per period =
Profit per unit × Effective units sold
Returns and allowances reduce effective volume and revenue. Adjusting for them gives a more realistic view of SKU profitability. Total profit per period shows how much profit the SKU contributes over a given time frame.
These formulas are intentionally straightforward. You can export the CSV and refine them in a spreadsheet—for example, by modeling different discount scenarios, cost changes, or overhead allocations. The goal is to give you a clear starting point for SKU‑level analysis, not to lock you into a single view.
Using SKU‑level profitability to shape product strategy
SKU‑level profitability is where merchandising, finance, and operations meet. A product can be popular and drive significant revenue, but if its unit economics are weak, it may quietly erode margin. Conversely, a modest‑volume SKU with strong margin can be a quiet hero in your portfolio. The SKU profitability analyzer is designed to help you see these dynamics clearly and make decisions with more confidence.
When you enter list price, discounts, net selling price, unit cost, shipping, overhead, units sold, and returns, the tool calculates margin percentage, profit per unit, and total profit per period. It also highlights effective units sold after returns and allowances. This combination gives you a compact but powerful view of how each SKU behaves financially.
Balancing price, cost, and discounting
Price and discounting are often the most visible levers, but cost and overhead quietly shape profitability. A SKU with aggressive discounting may still be healthy if unit cost and overhead are low. A SKU with premium pricing may struggle if costs are high or overhead allocation is heavy.
For example, imagine a premium hoodie with a 79 list price, 15% average discount, and 67.15 net selling price. Direct unit cost is 32, shipping and packaging are 6, and overhead per unit is 4. Total unit cost is 42, profit per unit is 25.15, and margin percentage is about 37.5%. If you sell 500 units per month with 3% returns, effective units sold are 485, and total profit per period is roughly 12,200. That’s a strong SKU.
Understanding the role of overhead
Overhead allocation can change the story. If you allocate more marketing or warehousing cost to the hoodie, total unit cost rises and margin falls. This may be appropriate if the SKU requires more support or storage. The analyzer’s overhead field lets you test different allocations and see how they affect profitability.
Overhead is not just a bookkeeping exercise; it reflects real resource use. A SKU that requires special handling, complex packaging, or heavy marketing may need a higher price or lower discounting to remain healthy. Seeing overhead per unit alongside direct cost and price helps you make those trade‑offs explicit.
Using returns and allowances wisely
Returns and allowances can quietly erode profitability. A SKU with high return rates may look strong on gross revenue but weak on net profit. By entering returns and allowances as a percentage, you can see how effective units sold and total profit change.
If returns are high, you might explore improving product descriptions, sizing guides, packaging, or quality control. You might also adjust pricing or discounting to better match customer expectations. The analyzer helps you quantify the impact of these changes on SKU‑level economics.
Practical example
Consider a kitchen gadget with a 29 list price and 10% average discount, yielding a 26.10 net selling price. Direct unit cost is 14, shipping and packaging are 3, overhead per unit is 2. Total unit cost is 19, profit per unit is 7.10, and margin percentage is about 27.2%. You sell 1,200 units per month with 5% returns, so effective units sold are 1,140. Total profit per period is roughly 8,100.
If your target margin percentage is 30%, this SKU is slightly below target. You might explore reducing cost, adjusting discounting, or increasing price modestly. The analyzer lets you test these scenarios quickly and see how they affect profit per unit and total profit.
Tips for using the SKU profitability analyzer effectively
- Use real data from your ERP, POS, or e‑commerce platform for price, cost, and volume.
- Run the analyzer for your top SKUs and for products you suspect may be underperforming.
- Experiment with different discount and overhead scenarios to see how sensitive profitability is.
- Include returns and allowances to avoid overestimating SKU performance.
- Export the CSV and combine it with portfolio‑level views to guide assortment and pricing decisions.
Ultimately, SKU‑level profitability is about clarity. It helps you see which products truly drive margin, which are strategic but low‑margin, and which may need to be redesigned, repriced, or retired. Combined with customer insights and operational context, the SKU profitability analyzer can be a practical tool for shaping a healthier, more resilient product portfolio.
Frequently Asked Questions
Should I use list price or net price for margin calculations?
Margin should be based on net selling price, because it reflects what customers actually pay after discounts. The analyzer lets you enter list price and discount or net price directly.
How do I decide on overhead allocation per SKU?
Overhead allocation is a judgment call. You can allocate based on volume, revenue, or specific resource use. The analyzer helps you test different allocations and see how they affect profitability.
Can I use this tool for bundles or kits?
Yes. Treat the bundle or kit as a single SKU and combine its price, cost, and overhead into per‑unit values. The analyzer will calculate margin and profit for the bundle.
How often should I review SKU profitability?
Many teams review SKU profitability quarterly or when planning assortment changes, promotions, or price updates. You may review more frequently for fast‑moving or seasonal products.
Does this tool change my inventory or accounting records?
No. The SKU profitability analyzer is purely analytical. It does not modify your inventory, ERP, or accounting data. Use it to interpret your numbers and inform decisions.
Can I compare multiple SKUs at once?
This tool focuses on one SKU at a time. You can export CSV results for multiple SKUs and combine them in a spreadsheet or BI tool for portfolio‑level comparisons.
Related tools
Information on this site is for educational purposes only and is not financial, tax, or legal advice. Calculations are estimates and may not reflect actual results. See our Privacy Policy and Disclaimer.