Calculate combined gross profit and margin for products with different costs, prices and quantities. The tool totals each row's unit cost × quantity and selling price × quantity, then calculates margin from the combined totals. This avoids the misleading result of simply averaging product margin percentages.
lightbulb When to use this tool
- check_circle Review gross profit for a basket or order containing several products with different quantities.
- check_circle Compare the overall margin of two product mixes without averaging individual percentage margins.
Inputs and results
Input: Product rows with unit cost, unit selling price and quantity. Product names are optional. The current price-column labels use INR (₹); keep every row in the same currency.
Output: Total cost, revenue, gross profit, aggregate gross margin and aggregate markup. Displayed amounts use your browser's number formatting; this tool does not convert currencies.
How it works
Enter each product's unit cost, unit selling price and quantity on its own row. Add rows as needed.
Use the same currency and cost basis for all products; optional product names help you keep rows distinct.
Calculate totals. Gross profit = revenue − entered cost; margin = gross profit ÷ revenue × 100; markup = gross profit ÷ entered cost × 100.
Inspect the combined percentages and check for loss-making rows or excluded costs before using the result in a quote or plan.
Examples
science Two products: a weighted 25% margin
Product A costs 80 and sells for 100, quantity 10. Product B costs 50 and sells for 100, quantity 2. Total cost is 900, revenue 1,200 and gross profit 300, giving margin 25% and markup 33.33%. The simple average of the individual 20% and 50% margins would be 35%, which is not this order's margin.
science A sale below cost produces negative margin
For unit cost 50, selling price 40 and quantity 10, total cost is 500 and revenue 400. Gross profit is −100, margin is −25% and markup is −20%, before any other business costs.
Limitations
Only the entered costs are included, so the result is not net business profit after overhead, tax, returns or financing. A zero revenue or cost denominator makes the corresponding percentage undefined, although the current display shows 0% in those cases. Use positive totals when interpreting ratios.
Frequently Asked Questions
Can I average the margin percentages of different products? expand_more
Why is aggregate markup different from aggregate margin? expand_more
Does this show net profit? expand_more
What does a negative margin mean? expand_more
Processing & Privacy
Processing uses your browser rather than uploading the supplied input to a processing server. Fonts and tool libraries can make third-party network requests. Optional analytics loads after consent. See the Privacy Policy for site-wide details.