Food manufacturing: understand the material cost of every recipe

01

The problem starts before the invoice

A recipe can remain unchanged while its cost drifts because of ingredient prices, actual yield or packaging constraints. Price per kilogram alone overlooks consumption needed for a conforming tonne. Procurement and production need a shared view of material cost and its drivers.

The question is not simply where to buy more cheaply. It is which information must come together before deciding, who can confirm the requirement and how to check the outcome after purchasing. Start with a manageable scope, retrieve existing records and make discrepancies discussable with the people who understand operations.

02

An application to develop with Kelqio

Recalculate recipe cost using documented prices and yields. Propose qualified alternatives and simulate their impact before production trials.

The approach connects supplier information, catalogues, requests and orders. Each proposal should retain original references, the effective date of the terms used and the decision owner. Buyers can accept a suggestion, correct it or explain why it does not apply. That response becomes useful information for the next transaction.

Material cost and bill of materials

Break down a manufacturing cost at constant specification and identify cost items to review.

What the monitoring could look like

⊕ Explore the mockup

See details in full size↗

Material cost and bill of materials

Zoom detailsClose ×

03

What makes a comparison useful

Demand planning needs to connect to the point when an order becomes firm. Information received after a delivery cutoff may still help operations but cannot change that purchase. Supplier calendars, minimum quantities and shelf life belong in the decision. A useful proposal shows what can be adjusted today and what has already been committed.

Keep events explaining demand alongside the historical data: exceptional closures, menu changes, promotions or unusual activity. Without these annotations, a system may repeat an anomaly. Starting with one category across complete operating cycles lets teams check that recommendations are usable before extending them to other items.

04

Bring the right data together

Bills of materials, ingredient specifications, approved alternatives, yields and quotes.

First, check a few lines from end to end. Do references match across sources? Do amounts use the same unit and period? Are terms still valid? File imports can support this initial review. More automated connections follow once matching is understood and responsibilities are assigned.

Data freshness needs to stay visible. Old stock records, expired rate cards or unapproved documents can make a proposal unusable. Signal missing information and retain the last reliable state rather than presenting an apparently precise calculation based on incompatible inputs.

05

An example to explain the calculation

Take a deliberately simplified example on a comparable purchase line in this scope. For 2,500 units actually ordered, a €35 baseline price and €34 obtained price produce a €2,500 gross difference. If implementation adds €200, the net benefit is €2,300. These figures are fictional and do not estimate the result your organization should expect.

This checks the arithmetic, not the performance of the whole approach. Confirm the unit, period and purchased service, then retain invoices and additional costs. Explain volume reductions, removed services or different quality separately. Benefits only become realized after the corresponding transactions occur.

06

Measure what actually changed

Material cost per conforming tonne.

Agree the baseline before claiming a benefit. Define scope, eligible volumes, quality, time period and costs required to change the situation. An identified opportunity, an approved decision, an order and an invoiced result are separate steps. Tracking them independently prevents an estimate from becoming a promise.

Cash released from lower inventory and staff time saved create value, but are not automatically recurring cash savings of the same amount. If outcome-based fees are appropriate, agree their calculation base. Subscriptions or fixed fees may better suit risk prevention and avoided costs that are difficult to verify.

07

Conditions for a useful result

Allergens, properties, quality and yield constrain substitutions. A cheaper recipe can cost more after rejection or rework.

Approval should match the consequence of the decision. A different pack size does not require the same review as a new critical reference. Teams need access to the explanation, documents and person who accepted the change. This traceability also supports disputes and rule corrections without removing history.

08

Start with a real case

Choose a category, site or contract where the problem can be observed. Gather sample orders, applicable terms and available outcome evidence. The first exercise should cover the whole chain: data, proposal, approval, action and measurement.

Then compare processing time, matching quality and verifiable results. Errors and rejected proposals matter as much as gains: they reveal missing information or constraints. Expand once owners have a method they understand and can use routinely.