Skip to main content
These examples use fictitious data, names and figures. Their content and format are illustrative; available results depend on the product you choose and the data you provide.

This case illustrates a possible project for discussion. Profitability, cash flow, receivables and simulation are not automatically included in Cortex: feasibility, data, scope, deliverables and pricing must be assessed first.

Demo reportSample report

Price, discount and cost simulator · Muebles Roble

Example business: Muebles Roble — a furniture workshop with three main products sold to stores and end customers.

The ten sections organize this illustrative example. Each product report has its own scope and format.

Analysis overview

Products or services, base period and objective of the simulation.

Simulated products
Standard chair, dining table and bookshelf.
Base period
Monthly average, January – June 2025
Objective
Compare three commercial changes before executing them.
Currency
USD

Executive summary

Highlighted scenarios and main differences.

Over a base contribution of USD 21,180 per month, three scenarios were simulated. The best calculated result combines a 6% chair price increase with the renegotiated wood cost (estimated contribution of USD 22,470, +6.1%). The volume discount on tables destroys contribution under every assumption tested.

  • The chair is the most price-sensitive product: it contributes 37% of the total.
  • No scenario includes cross-product effects; they are simulated independently.
  • Assumed volumes are business judgments, not measured elasticities.

Data quality and assumptions

Known variables and user-provided values.

Base prices, costs and volumes come from the sales file and the workshop’s cost sheets; they are known data. Volume responses to price changes were provided by the business as assumptions and are shown in each scenario.

  • Unit costs updated to June 2025 (materials and direct labor).
  • Workshop capacity (480 hours/month) acts as a constraint in every scenario.
  • There is no historical data on price-change reactions: elasticity was not estimated.

Base situation

Prices, costs, volume and margins.

The base situation is the half-year monthly average. Unit contribution is price minus variable cost; the workshop’s fixed expenses are not allocated per product.

Total monthly contribution

USD 21,180

Monthly revenue

USD 55,550

Units per month

410

Workshop hours used

452

Of 480 available

Base situation by product
ProductPriceVariable costUnits/monthContribution/month
Standard chairUSD 85USD 52240USD 7,920
Dining tableUSD 320USD 19860USD 7,320
BookshelfUSD 145USD 91110USD 5,940

Commercial scenarios

Price modifications and discounts.

Each scenario changes a single commercial variable versus the base and states its volume assumption. The calculation detail is in the annex.

Simulated commercial scenarios
ScenarioVolume assumptionEstimated contributionDifference vs. base
E1 · Chair price +6% (USD 90.10)Volume drops 8% (221 units)USD 21,663USD 483
E2 · Table with a 10% volume discountVolume rises 25% (75 units)USD 20,610-USD 570
E3 · E1 + wood cost −4% (renegotiated)Same assumptions as E1USD 22,470USD 1,290

Sensitivity

Effect of changes in costs and volume.

Sensitivity shows how much the base total contribution changes under isolated cost and volume variations, with no price changes. It sizes which risk weighs more.

Monthly contribution sensitivity
Simulated variationEffect on contributionResulting contribution
Wood cost +10%-USD 1,830USD 19,350
Total volume −10%-USD 2,118USD 19,062
Wood cost −4% (renegotiation in progress)USD 732USD 21,912

Result comparison

Revenue, total contribution, restrictions and conditions of each scenario.

The comparison brings the scenarios together under their declared assumptions. E3 is the best calculated result and fits workshop capacity (434 of 480 hours); E2 lands below the base even with the assumed volume increase, because the discount applies to the entire table volume.

Monthly contribution by scenario

Each scenario’s estimated total contribution under its assumptions.

  • BaseUSD 21,180
  • E1 · Chair price +6%USD 21,663
  • E2 · Table discountUSD 20,610
  • E3 · E1 + cost −4%USD 22,470

Explore with the pointer or keyboard. Tap a value to keep its detail visible.

  • Condition for E1/E3: monitor actual chair volume; if it drops more than 12%, the scenario stops being favorable.
  • Condition for E2: it would only pay off with a volume increase of 34% or more, which no data supports.

AI analysis

Advantages, risks and conditions needed to consider each alternative.

Key findings

Scenario E1 breaks even at a 12% drop

With the chair at USD 90.10, contribution equals the base if volume falls 12%. The assumption used (−8%) leaves room, but the threshold must be watched from week one.

Evidence: Commercial scenarios (element 5) and the annex calculation detail.

The table volume discount does not hold up

The 10% discount cuts unit contribution from USD 122 to USD 90; table sales would need to rise 34% just to break even, and the available assumption is 25%.

Evidence: Result comparison (element 7).

Wood cost outweighs volume in the risk picture

A 10% wood increase costs USD 1,830 per month and is outside the workshop’s control. The renegotiation in progress (−4%) is the only quantified cost lever.

Evidence: Sensitivity table (element 6).

Business interpretation

The decision with the best result-to-risk ratio is executing E3: the chair price increase is reversible and the cost improvement does not depend on demand. E2 should be discarded unless a purchase commitment guarantees the volume. Results are calculations conditional on the declared assumptions, not demand projections.

Hypotheses and limitations

  • The chair volume drop may be smaller than assumed if competitors keep higher prices; a market price review would bound it.
  • E2’s volume increase assumes stores pass the discount to end customers; if they keep it as margin, volume would not rise.

Prioritized recommendations

Priority: High

Execute E3 in stages

Apply the new chair price to the end-customer channel first (60% of volume), measure for two weeks and extend to the store channel if volume holds.

Priority: High

Close the wood renegotiation before the price change

The 4% discount already discussed with the supplier adds USD 732 per month with no commercial risk; it secures half of E3’s improvement.

Priority: Medium

Do not launch the table volume discount

Under the available assumptions the scenario destroys USD 570 per month. Reconsider only against a firm order guaranteeing 34% more units.

Proposed follow-up

Proposed follow-up
IndicatorReference valueReview period
Weekly chair units after the price changeBase of 55 units/week; reversal threshold: 48Weekly for 8 weeks
Total monthly contributionUSD 21,180 base → USD 22,470 expected under E3 (conditional on assumptions)Monthly close

Test plan

Changes to validate, limits and follow-up metrics.

Test plan
ActionSuggested ownerFollow-up metricPriority
Confirm the wood discount with the supplier in writingPurchasingChair and table unit costHigh
Raise the chair price in the end-customer channelSalesWeekly units versus the 48-unit thresholdHigh
Market price review of comparable chairsManagementPrice position versus 5 competitorsMedium

Methodology and annexes

Formulas, parameters and complete simulation results.

Contribution = (price − variable cost) × units. Each scenario recalculates contribution under its declared assumptions; the volume break-even comes from equating the scenario’s contribution to the base. No elasticities were estimated: alternative volumes are business assumptions.

  • Annex A: full calculation detail for the three scenarios.
  • Annex B: per-product cost sheets (materials and labor).
  • Annex C: workshop-hour usage per scenario.

Other sample reports

Apply the question to your data

This case illustrates a possible project for discussion. Profitability, cash flow, receivables and simulation are not automatically included in Cortex: feasibility, data, scope, deliverables and pricing must be assessed first.

Price, discount and cost simulator · Sample report · Valerian Data