Scenario Analysis for Alternative Formulations in Animal Nutrition

The animal feed production sector operates on historically tight margins. Feed plants, premix producers, and pet food manufacturers build their profitability on fractions of a cent saved per kilogram produced, and any unplanned variation in raw material cost can jeopardize months of financial results. Structural volatility in agricultural commodities, combined with dependence on ingredients priced in international markets with their own dynamics, turns formulation cost management into an activity that requires much more than reaction. It requires anticipation.

It's in this context that scenario analysis applied to formulation stops being a sophisticated technique reserved for large companies and becomes an accessible, necessary operational tool for any company that wants to plan its production intelligently. This article explains what this approach is, how it connects with precision formulation tools, and how it can be used to guide purchasing decisions, portfolio composition, and inventory management based on objective data.

What is scenario analysis applied to feed formulation

Scenario analysis is a technique originally developed in corporate finance to assess how different future conditions affect a business's results. At its core, it means systematically examining what happens to a relevant outcome, such as cost, margin, or an ingredient's consumption volume, when one or more input variables change within defined ranges. From these simulations, managers can draw up action plans for different possible futures, instead of reacting to them once they're already reality.

Applied to feed and animal-food formulation, this technique finds especially fertile ground because the linear optimization model underlying least-cost formulation is, by nature, sensitive to variations in input parameters. An ingredient's price changes, and the optimal solution changes with it. An ingredient's availability is limited, and the formula's composition adjusts to maintain technical and economic feasibility. Systematically and proactively simulating these changes is precisely what scenario analysis allows you to do.

The two dimensions of variables in the formulation model

To understand where scenario analysis fits into formulation, it helps to split the model's variables into two groups with quite different natures.

The first group is the formula's specifications, which includes the minimum and maximum nutritional requirements for each nutrient, relationships between nutrients such as amino acid ratios or calcium-to-phosphorus ratios, and the guarantee levels the product needs to meet to comply with regulations and the promises made to the customer. These variables have low flexibility for change. They're determined by the physiological requirements of the species and animal category, and once established, any deviation carries a direct risk to animal performance or to the product's regulatory compliance. Nutritionists and formulators treat them as model constraints, not as parameters to optimize.

The second group is the ingredients available for formulation, which includes purchase prices, minimum and maximum inclusion limits, each raw material's nutritional composition, and stock availability. Here flexibility is greater, and this is where scenario analysis creates value. When a raw material's price rises, the model can partially or fully replace it with alternative ingredients that deliver the same nutritional balance at a lower cost. The question is: at exactly what price does that substitution occur? In what quantity does each ingredient enter or leave the formula? And what's the total impact on cost per ton of the produced batch? Scenario analysis answers these questions before the price change happens in the market.

Parametric analysis: the technical tool behind scenario analysis

The tool that operationalizes scenario analysis within formulation software is called parametric analysis, also known as sensitivity analysis. In technical terms, it's the study of how a linear programming model's optimal solution varies when a specific parameter, such as an ingredient's price, changes within a defined range. For each value of the parameter within that range, the model performs a full re-optimization, always respecting all inclusion constraints and established nutritional requirements.

The result is a series of optimal formulations corresponding to each point in the parameter's variation range. The formulator defines a starting value, an ending value, and a variation increment, and the system automatically generates all the intermediate solutions. This set of results forms a decision map that precisely shows how the formula's behavior and the batch's total cost evolve as the analyzed parameter changes.

The re-optimization logic and the role of constraints

An important technical aspect of parametric analysis that's often not fully understood is that each simulated scenario is a genuinely optimal solution, not an interpolation or an estimate. The model solves the linear programming problem again for each parameter value, considering exactly the same set of constraints: each ingredient's inclusion limits, nutritional relationships, each nutrient's minimum and maximum requirements, and any other technical or operational constraint that has been configured.

This means that when a main ingredient's price rises and an alternative starts entering the formula in a greater proportion, the model also respects that alternative's inclusion limits. If the substitute ingredient hits its inclusion ceiling before it can fully compensate for the reduction in the main ingredient, the model redistributes the remaining ingredients to maintain the nutritional balance. The solution found at each scenario is always the most economical possible within the defined constraints. There's no manual interference between one point of the analysis and the next: the model decides automatically, based on objective criteria.

This characteristic turns parametric analysis into a much more powerful tool than a simple manual substitution simulation. The formulator doesn't need to guess which ingredient would replace which and in what proportion. The model finds the optimal combination for each price scenario on its own, revealing substitution dynamics that often surprise even those with years of experience with that formulation.

How to build scenarios relevant to the operation

The effectiveness of scenario analysis depends directly on how relevant the built scenarios are. Simulations that don't reflect plausible market variation ranges, or that aren't aligned with the company's real planning questions, produce results that are academically interesting but operationally useless. The choice of which parameters to simulate, which variation ranges, and which ingredients to include needs to be guided by concrete business questions.

The most practical starting point is identifying which ingredients carry the greatest weight in the company's total formulation cost across its portfolio. As a rule, two or three ingredients account for 50% to 70% of any formulation's raw material cost. These are the ingredients that deserve priority attention in scenario analysis, because variations in their price have a disproportionate impact on the operation's economic result.

Using market signals to define variation ranges

A very useful practice for adding realism to the analysis is using futures-market quotes for the main commodities as a reference for defining scenario variation ranges. Futures contracts for corn, soybeans, wheat, and other base ingredients provide a view of what the market expects for prices over the next 60, 90, or 180 days. When the formulator uses this price horizon as a benchmark, the simulated scenarios stop being hypothetical exercises and become projections anchored in real market information.

Scenario construction typically starts from three main simulations. The base scenario represents current ingredient cost and availability conditions, serving as a reference for measuring the impact of the others. The pessimistic scenario projects a significant rise in the main ingredient's price, testing the formulation's resilience and identifying the point at which alternatives need to kick in. The optimistic scenario simulates a price drop or improved availability, pointing to cost-reduction opportunities that could be captured if conditions materialize. Parametric analysis goes beyond these three fixed points and fills in the entire range between them, generating a continuous curve of the formulation's response to the parameter's variation.

Practical example: simulating corn price variation across a multi-product batch

To make the concept concrete, consider a company that produces a portfolio of nine products for dogs and cats, with a consolidated production forecast of 165 tons for the period. Corn is one of the main energy ingredients in most of these formulations, and its price outlook is trending upward over the coming weeks. The formulation team decides to run a parametric analysis of the corn price to understand the impact across the whole operation.

The formulator sets up the analysis with the current corn price as the starting value, defines a maximum price representing the worst expected scenario, and sets regular increments between these extremes — for example, R$0.05 at a time per kilogram — creating 21 simulation points across the entire range. For each of these 21 points, the system solves the complete optimization model for all nine products simultaneously, respecting all inclusion constraints and each formula's nutritional requirements.

The result is a table with 21 columns, each representing a price scenario, and rows showing each ingredient's inclusion level in the consolidated production and the total formulation cost of each product. The formulator can pinpoint exactly at what price level corn starts being replaced by other energy ingredients, the magnitude of that substitution in actual tons of raw material per period, and the batch's total cost in each scenario.

Inflection point and ingredient-substitution dynamics

One of the most valuable results of parametric analysis is identifying the inflection point — the exact price at which an ingredient stops being economically viable at a given proportion and an alternative ingredient starts coming into play. This point isn't intuitive and can rarely be estimated precisely without the optimization model.

In the corn example, the analysis might show that between the current price and a 10% increase, formula composition stays practically stable because there's no sufficiently competitive alternative to replace it in that range. Beyond a certain level, however, ingredients like DDGS, sorghum, or specific cereal byproducts gain economic advantage and start entering the formula in growing proportions. The model shows exactly when each transition happens and what the resulting composition is.

What happens to the other ingredients is also revealed by the analysis. When corn reduces its share, other energy ingredients take on part of its nutritional role, but each one's inclusion limits impose constraints. If sorghum reaches its maximum inclusion limit before fully compensating for the reduction in corn, the model redistributes the missing energy among other available ingredients, sometimes in ways that aren't obvious to the formulator. Having this visibility before the change happens in production is what separates reactive planning from strategic, data-driven planning.

Scenario analysis in multi-product portfolios: a consolidated view of the operation

One of the most strategic applications of parametric analysis is underused by companies that have it: portfolio-scale simulation, with all product lines calculated simultaneously. When the analysis is done product by product independently, the results are useful for understanding each formulation's behavior individually, but they don't show the consolidated impact on the operation as a whole.

When scenarios are built considering the entire production portfolio and its respective volume forecasts, the result of the parametric analysis is the consolidated consumption of each raw material under each price scenario. That number, expressed in tons or as a percentage of total consumption for the period, is exactly what the purchasing department needs to make supply decisions ahead of time and with objective criteria.

Suppose the consolidated analysis shows that, in the base scenario, the operation consumes 82 tons of corn in the period. In the scenario with a 15% price increase, consumption drops to 47 tons because cheaper alternatives enter in larger proportions. This data tells purchasing that buying corn stock above a certain volume in the pessimistic scenario would tie up capital in an ingredient the formulation itself is phasing out. Conversely, if the analysis shows that a modest price increase still keeps corn as the dominant ingredient, locking in a forward contract with the current supplier may be financially advantageous.

From analysis to purchasing planning: connecting formulation and supply

The value of scenario analysis is only fully realized when its results reach the department responsible for purchasing decisions with enough clarity and timeliness to guide concrete action. Unfortunately, in many companies in the sector, the results of formulation simulations stay within the technical team and never reach the purchasing department in a structured way. The formulator knows that beyond a certain price, corn loses viability, but that information never turns into an operational instruction for the buyer.

The bridge between scenario analysis and supply planning is built when the outputs of parametric analysis are presented as action plans: for scenario A, buy X tons of corn and Y tons of DDGS; for scenario B, reduce corn stock and increase sorghum position; for scenario C, trigger the rice bran supplier for a quote. These plans, tied to objective price triggers identified by the analysis, create a rapid-response mechanism that removes the need for improvisation when the market moves.

Scenario analysis as a common language between formulation and purchasingScenario analysis as a common language between formulation and purchasing

An operational benefit of scenario analysis that's rarely mentioned is its impact on the quality of dialogue between a company's technical and commercial teams. Formulators and nutritionists often struggle to explain to buyers and financial directors why a given ingredient should be avoided past a certain price, or why buying an alternative ingredient early makes economic sense. Technical arguments based on nutritional requirements and inclusion limits are legitimate, but they don't speak the cost-per-ton language purchasing uses day to day.

The results of a parametric analysis speak that language. A table showing that, beyond a given price per bag, corn raises the monthly batch's cost by R$X, and that DDGS at the current price would reduce that cost by R$Y, with consolidated volumes by ingredient for each scenario, is an objective argument any buyer can understand and use to guide their negotiations. This ability to create a shared factual basis between departments with different perspectives is one of the biggest practical gains of systematically implementing scenario analysis in an animal nutrition operation.

Strategic scenario-based planning: beyond reacting to price

Scenario analysis in formulation is usually presented almost exclusively as a response to commodity price volatility. But its scope is broader. The same simulation tools that answer questions about price variation can be used to assess the impact of ingredient availability constraints, regulatory changes that alter inclusion limits for certain raw materials, seasonal variations in the nutritional composition of specific ingredients, and even the entry of a new supplier with an analytical profile different from the current one.

Each of these situations can be modeled as a distinct scenario and simulated within the same formulation model, generating objective answers before the change materializes operationally. Companies that develop this scenario-planning culture, with periodic review of simulations aligned to the production planning cycle, progressively build an anticipation capability that translates into faster decisions, lower urgency costs, and greater margin stability over time.

Formulation software like Formulamix, from Optimal, offers native parametric analysis functionality, with an interface that lets the formulator configure variation ranges, run simulations for the consolidated batch, and view results as tables and charts that can be used directly to communicate with purchasing and production planning. This integration between formulation intelligence and operational planning is what turns scenario analysis from an isolated technical tool into a strategic process built into the company's routine.