Educational only: Business decision support, not accounting, tax or legal advice.
Privacy: No account is required. Tool inputs and results stay in this browser. Anonymous categorical usage analytics send only governed page, tool, cluster and action identifiers; tool inputs and results are never sent. Error monitoring is disabled. Optional saved state stays only on this device.
Update policy: Reviewed when formulas or official dependencies change.
Scope: Market-neutral small-business planning using your own assumptions.
What this planner helps you decide
Best for
Businesses comparing how a proposed product or service mix changes contribution.
Outputs
Current and proposed contribution, weighted margin and the contribution change.
Start here
Add comparable rows for the same period, then change volumes or economics one row at a time.
Use a different tool when: Do not use this to find the sales volume needed to preserve contribution after changing price; use PriceโVolume Trade-off Planner for that decision. Use this tool to compare contribution when the volume mix changes across products.
Profit & break-even
Product Mix Profit: current and proposed contribution
Current and proposed contribution, weighted margin and the contribution change.
Amounts use the same currency as your inputs. No currency conversion is performed.
Product mix assumptions
Enter 1โ20 products. Prices and unit costs exclude indirect tax.
Mix comparison
Contribution view, excluding indirect tax.
PDF and CSV exports stay on this device. Clean page links contain no inputs.
The proposed mix changes total contribution by 640.00. Compare each product's current and proposed contribution below.
Current contributionProposed contribution
| Product | Current contribution | Proposed contribution |
|---|---|---|
| Core product | 4,000.00 | 3,200.00 |
| Premium product | 1,800.00 | 3,240.00 |
| Product | Current contribution | Proposed contribution | Change |
|---|---|---|---|
| Core product | 4,000.00 | 3,200.00 | -800.00 |
| Premium product | 1,800.00 | 3,240.00 | 1,440.00 |
Product mix scenarios
Save the current and proposed mix, then change product economics or volumes to compare the impact.
ScenarioResultDifference
Current product mix5,800.00Baseline
Proposed product mix6,440.00640.00
Save these results, change an input, then compare the updated figures with this baseline.
The baseline is temporary in this tab and is not added to shared scenario links or generated reports.
Calculation details
View calculation detailsView the formulas and inputs used for these results.
Contribution change
Current mix contribution
sum current product contribution5,800/period ex indirect taxProposed mix contribution
sum proposed product contribution6,440/period ex indirect taxContribution change
proposed mix contribution โ current mix contribution640 per period ex indirect taxResult640.00
Proposed minus current contribution for the selected planning period, ex indirect tax. Displayed to the nearest cent; the engine retains full precision.
Product-mix contribution formulas โInputs used by these formula steps
- Current mix contributionProduct Rows
- 2
- Proposed mix contributionProduct Rows
- 2
- Contribution changeProposed Contribution
- 6,440
- Contribution changeCurrent Contribution
- 5,800
Proposed contribution
Proposed mix contribution
sum proposed product contribution6,440/period ex indirect taxResult6,440.00
Sum of proposed product contribution for the selected period, ex indirect tax. Displayed to the nearest cent; the engine retains full precision.
Proposed mix contribution formula โInputs used by these formula steps
- Proposed mix contributionProduct Rows
- 2
Current weighted contribution margin
Current weighted contribution margin
current mix contribution รท current mix revenue41.43%Result41.4%
Current mix contribution divided by current mix revenue. Displayed to two percentage decimal places when revenue is positive. Unavailable when current mix revenue is zero.
Weighted contribution-margin formula โInputs used by these formula steps
- Current weighted contribution marginContribution
- 5,800
- Current weighted contribution marginRevenue
- 14,000
Proposed weighted contribution margin
Proposed weighted contribution margin
proposed mix contribution รท proposed mix revenue42.37%Result42.4%
Proposed mix contribution divided by proposed mix revenue. Displayed to two percentage decimal places when revenue is positive. Unavailable when proposed mix revenue is zero.
Weighted contribution-margin formula โInputs used by these formula steps
- Proposed weighted contribution marginContribution
- 6,440
- Proposed weighted contribution marginRevenue
- 15,200
Core product current contribution
Core product current contribution
(price ex indirect tax โ unit cost ex indirect tax) ร current units4,000 per period ex indirect taxResult4,000.00
Product contribution for current units in the selected period, ex indirect tax. Displayed to the nearest cent; the engine retains full precision.
Per-product contribution formula โInputs used by these formula steps
- Core product current contributionPrice Ex indirect tax
- 100
- Core product current contributionUnit Cost Ex indirect tax
- 60
- Core product current contributionUnits
- 100
Core product proposed contribution
Core product proposed contribution
(price ex indirect tax โ unit cost ex indirect tax) ร proposed units3,200 per period ex indirect taxResult3,200.00
Product contribution for proposed units in the selected period, ex indirect tax. Displayed to the nearest cent; the engine retains full precision.
Per-product contribution formula โInputs used by these formula steps
- Core product proposed contributionPrice Ex indirect tax
- 100
- Core product proposed contributionUnit Cost Ex indirect tax
- 60
- Core product proposed contributionUnits
- 80
Premium product current contribution
Premium product current contribution
(price ex indirect tax โ unit cost ex indirect tax) ร current units1,800 per period ex indirect taxResult1,800.00
Product contribution for current units in the selected period, ex indirect tax. Displayed to the nearest cent; the engine retains full precision.
Per-product contribution formula โInputs used by these formula steps
- Premium product current contributionPrice Ex indirect tax
- 200
- Premium product current contributionUnit Cost Ex indirect tax
- 110
- Premium product current contributionUnits
- 20
Premium product proposed contribution
Premium product proposed contribution
(price ex indirect tax โ unit cost ex indirect tax) ร proposed units3,240 per period ex indirect taxResult3,240.00
Product contribution for proposed units in the selected period, ex indirect tax. Displayed to the nearest cent; the engine retains full precision.
Per-product contribution formula โInputs used by these formula steps
- Premium product proposed contributionPrice Ex indirect tax
- 200
- Premium product proposed contributionUnit Cost Ex indirect tax
- 110
- Premium product proposed contributionUnits
- 36
Inputs used
- Core product price ex indirect tax
- 100
- Core product unit cost ex indirect tax
- 60
- Core product current units
- 100
- Core product proposed units
- 80
- Premium product price ex indirect tax
- 200
- Premium product unit cost ex indirect tax
- 110
- Premium product current units
- 20
- Premium product proposed units
- 36
Open this calculator with preset values
This calculator supports documented, shareable scenario URLs. Compatible assistants and applications can construct links using the parameters below.
Scenario links contain only allowlisted numeric and closed-choice inputs shown in the URL; Margin101 excludes free text and identifying fields. Anyone you share the URL with can read those numbers, so do not include private or identifying data.
| Parameter | Meaning | Unit | Allowed values | Presence | Default |
|---|---|---|---|---|---|
| products | Number of product rows encoded in the scenario. | whole product rows | 1 to 20 | Required | 2 |
| r0_baseline | row 0 baseline for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | 100 |
| r0_cost | row 0 cost excluding indirect tax. | currency units/product unit ex tax | 0 to 1000000000000 | Optional | 60 |
| r0_price | row 0 price excluding indirect tax. | currency units/product unit ex tax | 5e-324 to 1000000000000 | Optional | 100 |
| r0_proposed | row 0 proposed for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | 80 |
| r1_baseline | row 1 baseline for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | 20 |
| r1_cost | row 1 cost excluding indirect tax. | currency units/product unit ex tax | 0 to 1000000000000 | Optional | 110 |
| r1_price | row 1 price excluding indirect tax. | currency units/product unit ex tax | 5e-324 to 1000000000000 | Optional | 200 |
| r1_proposed | row 1 proposed for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | 36 |
| r10_baseline | row 10 baseline for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r10_cost | row 10 cost excluding indirect tax. | currency units/product unit ex tax | 0 to 1000000000000 | Optional | โ |
| r10_price | row 10 price excluding indirect tax. | currency units/product unit ex tax | 5e-324 to 1000000000000 | Optional | โ |
| r10_proposed | row 10 proposed for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r11_baseline | row 11 baseline for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r11_cost | row 11 cost excluding indirect tax. | currency units/product unit ex tax | 0 to 1000000000000 | Optional | โ |
| r11_price | row 11 price excluding indirect tax. | currency units/product unit ex tax | 5e-324 to 1000000000000 | Optional | โ |
| r11_proposed | row 11 proposed for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r12_baseline | row 12 baseline for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r12_cost | row 12 cost excluding indirect tax. | currency units/product unit ex tax | 0 to 1000000000000 | Optional | โ |
| r12_price | row 12 price excluding indirect tax. | currency units/product unit ex tax | 5e-324 to 1000000000000 | Optional | โ |
| r12_proposed | row 12 proposed for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r13_baseline | row 13 baseline for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r13_cost | row 13 cost excluding indirect tax. | currency units/product unit ex tax | 0 to 1000000000000 | Optional | โ |
| r13_price | row 13 price excluding indirect tax. | currency units/product unit ex tax | 5e-324 to 1000000000000 | Optional | โ |
| r13_proposed | row 13 proposed for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r14_baseline | row 14 baseline for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r14_cost | row 14 cost excluding indirect tax. | currency units/product unit ex tax | 0 to 1000000000000 | Optional | โ |
| r14_price | row 14 price excluding indirect tax. | currency units/product unit ex tax | 5e-324 to 1000000000000 | Optional | โ |
| r14_proposed | row 14 proposed for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r15_baseline | row 15 baseline for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r15_cost | row 15 cost excluding indirect tax. | currency units/product unit ex tax | 0 to 1000000000000 | Optional | โ |
| r15_price | row 15 price excluding indirect tax. | currency units/product unit ex tax | 5e-324 to 1000000000000 | Optional | โ |
| r15_proposed | row 15 proposed for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r16_baseline | row 16 baseline for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r16_cost | row 16 cost excluding indirect tax. | currency units/product unit ex tax | 0 to 1000000000000 | Optional | โ |
| r16_price | row 16 price excluding indirect tax. | currency units/product unit ex tax | 5e-324 to 1000000000000 | Optional | โ |
| r16_proposed | row 16 proposed for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r17_baseline | row 17 baseline for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r17_cost | row 17 cost excluding indirect tax. | currency units/product unit ex tax | 0 to 1000000000000 | Optional | โ |
| r17_price | row 17 price excluding indirect tax. | currency units/product unit ex tax | 5e-324 to 1000000000000 | Optional | โ |
| r17_proposed | row 17 proposed for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r18_baseline | row 18 baseline for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r18_cost | row 18 cost excluding indirect tax. | currency units/product unit ex tax | 0 to 1000000000000 | Optional | โ |
| r18_price | row 18 price excluding indirect tax. | currency units/product unit ex tax | 5e-324 to 1000000000000 | Optional | โ |
| r18_proposed | row 18 proposed for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r19_baseline | row 19 baseline for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r19_cost | row 19 cost excluding indirect tax. | currency units/product unit ex tax | 0 to 1000000000000 | Optional | โ |
| r19_price | row 19 price excluding indirect tax. | currency units/product unit ex tax | 5e-324 to 1000000000000 | Optional | โ |
| r19_proposed | row 19 proposed for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r2_baseline | row 2 baseline for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r2_cost | row 2 cost excluding indirect tax. | currency units/product unit ex tax | 0 to 1000000000000 | Optional | โ |
| r2_price | row 2 price excluding indirect tax. | currency units/product unit ex tax | 5e-324 to 1000000000000 | Optional | โ |
| r2_proposed | row 2 proposed for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r3_baseline | row 3 baseline for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r3_cost | row 3 cost excluding indirect tax. | currency units/product unit ex tax | 0 to 1000000000000 | Optional | โ |
| r3_price | row 3 price excluding indirect tax. | currency units/product unit ex tax | 5e-324 to 1000000000000 | Optional | โ |
| r3_proposed | row 3 proposed for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r4_baseline | row 4 baseline for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r4_cost | row 4 cost excluding indirect tax. | currency units/product unit ex tax | 0 to 1000000000000 | Optional | โ |
| r4_price | row 4 price excluding indirect tax. | currency units/product unit ex tax | 5e-324 to 1000000000000 | Optional | โ |
| r4_proposed | row 4 proposed for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r5_baseline | row 5 baseline for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r5_cost | row 5 cost excluding indirect tax. | currency units/product unit ex tax | 0 to 1000000000000 | Optional | โ |
| r5_price | row 5 price excluding indirect tax. | currency units/product unit ex tax | 5e-324 to 1000000000000 | Optional | โ |
| r5_proposed | row 5 proposed for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r6_baseline | row 6 baseline for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r6_cost | row 6 cost excluding indirect tax. | currency units/product unit ex tax | 0 to 1000000000000 | Optional | โ |
| r6_price | row 6 price excluding indirect tax. | currency units/product unit ex tax | 5e-324 to 1000000000000 | Optional | โ |
| r6_proposed | row 6 proposed for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r7_baseline | row 7 baseline for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r7_cost | row 7 cost excluding indirect tax. | currency units/product unit ex tax | 0 to 1000000000000 | Optional | โ |
| r7_price | row 7 price excluding indirect tax. | currency units/product unit ex tax | 5e-324 to 1000000000000 | Optional | โ |
| r7_proposed | row 7 proposed for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r8_baseline | row 8 baseline for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r8_cost | row 8 cost excluding indirect tax. | currency units/product unit ex tax | 0 to 1000000000000 | Optional | โ |
| r8_price | row 8 price excluding indirect tax. | currency units/product unit ex tax | 5e-324 to 1000000000000 | Optional | โ |
| r8_proposed | row 8 proposed for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r9_baseline | row 9 baseline for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
| r9_cost | row 9 cost excluding indirect tax. | currency units/product unit ex tax | 0 to 1000000000000 | Optional | โ |
| r9_price | row 9 price excluding indirect tax. | currency units/product unit ex tax | 5e-324 to 1000000000000 | Optional | โ |
| r9_proposed | row 9 proposed for the comparison period. | whole product units/period | 0 to 1000000000 | Optional | โ |
Product Mix Profit: current and proposed contribution
Use the contribution change to judge whether the proposed sales mix improves unit economics for the same planning period.
Formula summary
- Primary formula
- mix contribution = ฮฃ((price ex indirect tax โ unit cost ex indirect tax) ร units)
Data used here
- The estimate uses your inputs and the general business formula documented in the methodology.
Decision checks
Act on the result
Identify which product or service creates the mix change and align sales, stock or capacity priorities with that result.
Stress-test the decision
Retest lower volume or margin for the proposed mix instead of assuming every planned sale will occur.
When this estimate can be misleading
- This is a contribution model, not an accounting profit statement.
- It assumes each product price and unit cost remain constant.
- It excludes shared fixed costs, capacity, stock, cash timing and income tax.
- Use the contribution change to judge whether the proposed sales mix improves unit economics for the same planning period.
Educational estimate, not advice. See all assumptions & limitations โ
Related reading
Guides to interpret the decision and its assumptions.
- Small-Business Profitability: Read the Profit Layers
Separate contribution, gross profit and operating profit so each result supports the decision it actually measures.
Read guide - How to Review SKU and Product-Mix Profit
Compare product rows using contribution, weighted margin and total contribution rather than revenue alone.
Read guide - Which Product Should a Business Stop Selling?
Review contribution, constrained capacity, strategic role and avoidable costs before deciding whether to change, pause or discontinue a product.
Read guide - Product Mix Shift: Why Revenue Can Rise While Margin Falls
Use a comparable-period contribution bridge to isolate mix from price, cost and quantity before changing the portfolio.
Read guide
Frequently asked questions
How do I compare contribution when the volume mix changes across products?
Identify which product or service creates the mix change and align sales, stock or capacity priorities with that result.
Which planning assumptions should I stress-test?
Compare a plausible alternative scenario and verify the decision-critical assumption that changes the plan most.