Illustrative material · modelling business parameters
How I model production profitability
An interactive break-even model for an industrial-products plant. Move the sliders on the left to see how changes in price, material cost, staffing or fixed costs translate into the break-even point and the sales result.
Model parameters
Break-even point
units / year
Production capacity
units / year
Contribution margin M2
PLN / year
M2 margin
% of revenue
Total revenueTotal costsBreak-even point (BEP)Production capacity
The intersection of the curves marks the volume at which revenue covers costs. The area to the right of the intersection is the profit zone; the dashed vertical line shows the production-capacity limit resulting from staffing and available working hours.Forecast market potential split into two product groups, compared against the plant’s break-even point and production capacity. The comparison shows in which years the market allows the profitability threshold to be exceeded, and where the constraint becomes production capacity rather than demand.
What the model does. The model splits costs into fixed (independent of volume — rent, utilities, salaried staff, staffed production positions) and variable (materials and outsourced services, growing in proportion to the number of units). The difference between price and variable cost gives the contribution margin per unit; dividing fixed costs by the contribution margin yields the break-even point. Comparing the threshold against the market forecast and production capacity answers the question of whether the venture makes economic sense — and under what assumptions it stops making sense.