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
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.
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.
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.
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
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.
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.
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
Test plan
Changes to validate, limits and follow-up metrics.
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.