Process manufacturing ERP: formulas and recipes
Process manufacturers transform materials into completely new products. They convert agricultural products and chemicals into intermediate products, and for final consumption. Unlike a discrete manufacturer’s products, those of a process manufacturer can never be converted back to their original state.
Managing and maintaining recipes and formulas is one of the most important ongoing activities for many process manufacturers. Management never stops as new ingredients become available or existing ones become unavailable. Food processors continually need to reduce costs. Pharmaceutical businesses must deal with changes to compliance rules. Chemical producers must manage environmental concerns. So what do you need from your ERP system to manage these changes efficiently and meticulously?
A requirement common to all process manufacturers is the need for configurability in the formulation management module. ERP must be able to use both volume and weight for recipe ingredient management and reporting.
In food production, for instance, the ingredients might be in weight as they are added to the process, but nutritional information regulations require reporting of the same ingredients on the label by volume. This configurability is also vital in global manufacturers who must switch between units of measurement to accommodate local expectations.
Formulas and recipes
A formula consists of ingredients and quantities needed to produce a specific quantity of some product. The formula includes processing steps and processing time required to produce that same quantity.
Your formulations are often based on nominal quantities that will yield a standard output. If your industry is particularly susceptible to material shortages, your ERP should be able to work backward starting with the available amount of the short material to calculate a revised formulation and expected yield. This yield would then need to be fed into your inventory and sales module in real-time to avoid any backorders.
Each ingredient can scale in different ways as the production quantity changes. Some ingredients will double as the production quantity changes from 10 to 20 units of output. Another ingredient is required in a single quantity regardless of the expected output. Think of yeast when baking bread. That little package is all you need whether baking a single loaf or a dozen loaves.
The requirement for scaling is especially important. You might have a demand for 100,000 Kg. You do not want an ERP that only allows production in batches of 40,000 Kg., as you will be over or short of demand by a significant quantity. True demand should rule and not some artificial limit imposed by your ERP system.
Along a similar line to material shortages, many recipes and formulations stored in ERP must also cope with material substitutions. A drug might not permit substitutions for a component that must come from a certain manufacturer. Another chemical could be switched between two or three different suppliers with no change to the formulation. Still, another might allow a substitution, but only if the quantity required is increased and another reagent is substituted.
ERP also has to deal with by-products. You are making product A, but halfway through the process, you drain off unnecessary liquid. There is a market for that liquid so it is not waste but a product B you can sell on the side. The expected output from a production job usually will include a positive quantity of product A and a negative quantity of product B (which signifies you are moving a quantity of that product back to inventory after the job is complete) and an ERP system for a process manufacturer will meet that requirement.
Co-products are also common with process manufacturers. A co-product could be a secondary item or, often, the co-product is another product that is made from the same or similar ingredients and follows the same process flow. Co-products will both be included as expected outputs from a production job.
Catchweight originates with the fishing industry. A ship returning from the fishery will have a known weight of fish and a cannery or other food processor will buy that weight. Only after sorting will the exact weight of several kinds of fish be known and only after processing will we know the weight of the actual useful yield of those fish separated from the bone and other scrap.
The same phenomenon is frequently found with many types of food processing. Someone buys a truckload of steers based on the gross minus tare of the trailer. Later we learn the weight of meat those steers will yield.
Compliance is an important requirement for all businesses today including those who use process manufacturing.
CGMP, or current good manufacturing practices, is a critical measure of whether an ERP is suited for process manufacturers. The business’ quality management systems defines their good manufacturing practices and the formulas and recipes captured in the ERP control whether production work will be used for those jobs. Further, when employees capture their time, and as ingredients are issued to those jobs, the actual time and materials used can easily be compared to the CGMP standards within those jobs.
HACCP, or hazard analysis and critical control points, is a preventative approach to guard against and control biological, chemical, and physical hazards from procurement, handling, and production through manufacturing, distribution, and consumption of products. These safeties relate particularly to process manufacturers. Those critical control points should be documented in the process flow component of formulas and recipes. At each point, an appropriate measurement should be made and recorded in the ERP system ensuring that many HACCP requirements are met.
Process manufacturers must track procured ingredient materials as well as intermediate and final production items. Lot numbers are a common way to enable this necessary tracking. At the time an item is added to inventory, whether through production or procurement, a lot number is assigned. Then as that lot is issued to subsequent production jobs or sold to consumers, the lot number issued is part of the ERP record. Later, if any problems arise, the manufacturer can easily and quickly drill down from the lot number of the suspected problem through every ingredient lot ever used in the production of that suspected lot. The manufacturer can also then drill upward from those ingredient lots to determine if a problem lot was used elsewhere and there could be yet unidentified concerns with other sold lots.
Many products must report the proportion of ingredients a percentage of the final product. This is the result of simple math when both the ingredient and the final product use the same class of measurements such as milligrams and ounces. How do you calculate the percentage when the final product is measured in milligrams and the ingredient in a volume measurement such as liters? What about when the liquid is consumed during production by evaporation or a chemical reaction? This situation is common and process manufacturing ERP systems must be able to reconcile a wide variety of situations when the formula and recipe use different units of measurement.
Some products made by process manufacturers will yield different grades in the final products. The formula or recipe might be identical and the processes involved seem the same but the ingredients are organic matter so Mother Nature governs some of the results and not necessarily the manufacturer. The highest-grade yield sells for the highest margin and has the most customer demand. However, lower-grade yields also can be sold profitably. If your products yield different grades, be certain the ERP you choose can adequately handle your requirements.
Process manufacturers must have controls over shelf life at the final product level as well as the ingredient level. Compliance requirements tell the manufacturer to publish a use-by date or a best-consumed-by date label on the products it sells. The ERP system will calculate that date based on the dates of the manufacturing process steps and the age of ingredients. Both these factors are related to the formula or recipe the manufacturer uses.
Ingredient shelf life usually is related to the procurement date of the ingredient. ERP should capture the procurement date and track the usage of the ingredient. A stale ingredient should not be used at any time in production and the manufacturer will normally manage inventory to schedule use well ahead of the shelf life expiration date. In cases where there is no demand, the manufacturer will know to dispose of that ingredient from inventory well ahead of any time when its use will be a problem.
Reasons to change a formula
Once you have a formula or recipe that yields the desired product many would say, “Leave well enough alone”. However, that is not always possible, or even necessarily the best course of action. Some ingredients might become unavailable unexpectedly or become too costly due to conditions beyond the manufacturer’s control.
Process manufacturers have the same pressures as any business to constantly reduce costs. If a lower-priced ingredient becomes available, there is a good reason to change the recipe. The process itself might be changed which means the formula will change. Perhaps someone finds a way to reduce mixing time or the business decides to purchase a new mixer that reduces the necessary time. Once the revised process is defined and documented, update the ERP system to lock in the improvement.
Changing a recipe or formula is a significant task, as extensive testing is needed to ensure the product has not changed and will meet all the requirements from customers and compliance enforcement. Engineers might feel the formula they developed over time and with difficulty is the best possible formula and hesitate to make a change regardless of the reasons for change. Your business will need to carefully evaluate to ensure the benefits outweigh the risks. Then begin the testing process again to certify the revised formula or recipe will be satisfactory.
One ERP feature that is a requirement for almost all process manufacturers is the ability to track lot numbers. Backward lot traceability means that when a customer inquires about a lot they received, you can trace every ingredient back to the incoming lot from every supplier. In the case of a food manufacturer, that means all the way to the field the crop was grown on. Forward lot traceability means that we can start with any incoming supplier lot number in our process manufacturing ERP and know exactly which production lots used which materials and which customers received products containing any of the materials from that supplier lot number.
In some cases, lot traceability may be internal. There might be an interim formulation that is never sold but is later used as an ingredient in one or more downstream production lots.
Lot traceability within process manufacturing ERP is often a requirement by regulatory bodies and is also required by customers. Supplier lot numbers come in a wide variety of formats and your ERP must be flexible enough to handle any format. Some final sales lot numbers are in a format required by a customer or an external regulation but usually, the format is specified internally. The lot number is always related to the production job the product is made under and often that job number is part of the lot number.
Maximizing efficiency, minimizing risk
Many products have a shelf life or an expiration date. That date will be related to specific lots. Particular lot numbers might have specific safety factors that must be provided to customers and be available to regulatory agencies. Those lots will have their own MSDS published. A lot number can also relate to a manufactured date or the date the ingredients were mixed. An expiration date could relate to a particular ingredient which might be the controlling factor in the product’s life. All these variables affect inventory quality which, in turn, affects the efficiency of the process manufacturing process. With this in mind, these variables should be tightly controlled within your process manufacturing ERP system.
In some cases, a single production lot might be divided into several sales lot numbers. Many products are graded - the best output will have one set of lot numbers and lower-level output will be assigned others. Co-products and by-products will receive their own lots too.
Many products of process manufacturers are hazardous on their own and others can be hazardous after unexpected reactions. Still, others might be found later to be tainted. People’s lives are at stake so the potential for a disaster is present. Even if no people are harmed, the financial risk from lawsuits or regulatory penalties can bankrupt a business. It is critical for process manufacturing ERP users to maintain lot traceability processes and use their ERP properly to minimize risks.
Whatever process manufacturing ERP system you choose, formulas and recipes are at the heart of the system. Those formulas and recipes must be versatile as well as powerful. They also must be agile to enable your business to react to changes in demands or supplies quickly and accurately. Your products depend on them in order that you can produce the products with the quality your customers depend upon. Beyond your own customers, there is a world full of government and industry standards your ERP must help you meet. Even if your customers like your products any of these third parties can make your business life difficult or even put you out of business. Make certain the ERP you choose both defends the way you make your product and enables you to continue making and improving the products your customers want. Process manufacturing ERP formulas and recipes perform similar work to a discrete ERP bill of material while resolving much more difficult working conditions.
Featured white papers
Manufacturing ERP: 10 steps to success
Complete step-by-step guide to manufacturing ERP softwareDownload
Manufacturing ERP Implementation Checklist
Over 70 actionable steps to rolling out new manufacturing ERP softwareDownload
Top 10 Manufacturing ERP Software Comparison
Compare the best manufacturing ERP systemsDownload
Why a food specific ERP system is a must-have
Key features and requirements food companies should consider when searching for an ERP
Why a food specific ERP system is a must-have
Key features and requirements food companies should consider when searching for an ERP
What industrial manufacturers should look for in ERP
The most important features to look for in an industrial manufacturing ERP