Industries · Process manufacturing

Every batch with its recipe, raw materials and cost

Makers of wine and beverages, dairy, bakery, canned food, chemicals or cosmetics work with recipes and batches, using raw materials that expire. Business Central links purchasing, production, the warehouse, sales and finance, so you know which raw materials went into every batch, who received it and what it cost.

In recipe-⁠based production, everything depends on the batch and the expiry date

Raw materials arrive in lots with different expiry dates, the recipe is adjusted to their quality, and part of the input is lost in the process. If lots are recorded on paper, a product recall means days of searching. A shared record shows in a few clicks where every ingredient came from and where every batch went.

Challenges

Key Challenges for Recipe-⁠Based Manufacturers

Common situations in food, beverages, chemicals and cosmetics.

  • There is no quick way to find which product batches used a given raw material
  • Raw materials expire in stock or are used in the wrong order
  • Recipes and their changes are kept in notebooks and Excel files
  • The actual yield of a batch is not compared with the standard
  • The same product is counted in kilograms, litres and units, and conversions are done by hand
  • The cost of a batch is calculated after the goods have already been sold
What Business Central covers

Recipes, batches and cost in one system

Standard Business Central manufacturing features; they are part of the Premium licence. Co-⁠products, potency-⁠based calculation, batch quality control and other specific requirements are analysed separately.

Recipes and processes

The recipe and production steps, with versions and planned losses.

  • Multi-⁠level recipes (intermediates)
  • Recipe versions with start dates
  • Planned process losses
  • Units of measure: kg, l, pcs

Lots and expiry dates

Every raw material and finished product has its own lot and expiry date.

  • Lot numbers at receipt and at output
  • Expiry dates
  • Picking by first expiry (FEFO)
  • Blocking a lot until it is checked

Traceability

From the supplier's lot to the customer who received the product, and back.

  • Forward and backward lot tracing
  • Lot consumption on every production order
  • Customer list for a product recall
  • Quality status and certificate number by lot

Batch cost

What every batch cost and where the margin was lost.

  • Raw materials, packaging, labour and overheads
  • Actual yield against standard
  • Freight and customs in raw material cost
  • Margin by product, channel and customer
Benefits

What a recipe-⁠based manufacturer gains

Results depend on your processes and data quality. Here is what becomes possible.

Batches found without searching

See at once which raw materials went into a batch and who received it.

Less expired raw material

Expiry dates are visible in stock, and picking starts with the lot that expires first.

The actual cost of every batch

Compare yield and consumption with the recipe and see where margin is lost.

First step

Start from the business processes, not from licenses

Enter a few company parameters and instantly receive a preliminary project estimate.