Calculator Inputs
Enter revenue, cost, and analytical weight for each segment. Use weights to reflect importance, confidence, or business priority.
Example Data Table
Use this sample structure to understand how weighted margin analysis works across business segments.
| Segment | Revenue | Cost | Weight | Margin % |
|---|---|---|---|---|
| Retail Analytics | $120,000.00 | $72,000.00 | 1.30 | 40.00% |
| Subscription Cohort | $95,000.00 | $28,500.00 | 1.80 | 70.00% |
| Enterprise Bundle | $160,000.00 | $104,000.00 | 1.10 | 35.00% |
| Partner Channel | $60,000.00 | $48,000.00 | 0.90 | 20.00% |
Formula Used
1) Segment Margin %
This measures the profitability of each segment before weights are applied.
2) Weighted Margin %
This is the primary weighted average margin. It reflects custom analytical importance.
3) Weighted Gross Margin %
This blends weighted profit against weighted revenue. Larger revenue rows can affect it more strongly.
4) Net Margin % After Overhead
This adjusts the scenario for a fixed overhead value after weighted profit is calculated.
How to Use This Calculator
Step 1
Enter a scenario label. Add optional fixed overhead and a target margin percentage.
Step 2
Fill each segment card with a name, revenue value, cost value, and weight.
Step 3
Use higher weights for more important, reliable, or strategically meaningful segments.
Step 4
Click the calculate button. The summary appears above the form, directly below the header.
Step 5
Review the chart, compare segment influence, and export the outcome as CSV or PDF.
Frequently Asked Questions
1) What does weighted margin mean?
Weighted margin is an average margin rate that gives each segment a different influence. Higher weights make selected rows affect the final result more strongly than others.
2) When should I use custom weights?
Use custom weights when some observations matter more, such as larger markets, priority cohorts, trusted experiments, or forecast-critical customer groups.
3) Why is weighted margin different from weighted gross margin?
Weighted margin averages row-level margin percentages by weight. Weighted gross margin blends weighted profit and weighted revenue, so larger revenue values can shift the final percentage.
4) Can costs exceed revenue?
Yes. The tool allows negative margins. That helps you detect loss-making segments and understand how heavily they pull the blended result downward.
5) What does fixed overhead change?
Fixed overhead is subtracted after weighted gross profit. It does not change row margins, but it lowers the net margin percentage for the full scenario.
6) How many segments can I test?
This version includes six segment cards. You can rename each row and leave unused cards empty when analyzing smaller datasets.
7) What should I use as weights?
Use values that reflect importance, reliability, volume, forecast priority, or analytical confidence. Keep the same meaning across all rows for a fair comparison.
8) Can I export results?
Yes. Use the CSV button for spreadsheet work and the PDF button for shareable summaries after you calculate a scenario.