Configuring Formula Items and Planning Items

In the world of manufacturing and supply chain management, not every product is built the same way. If you are putting together a bicycle, you have a clear list of parts: two wheels, one frame, one handlebar. This is known as discrete manufacturing, and it relies on a Bill of Materials (BOM). However, if you are making a batch of industrial-grade paint, a gallon of premium vanilla ice cream, or refining crude oil, the rules change. You are no longer just "assembling" parts; you are mixing ingredients, managing chemical reactions, and dealing with outputs that might include multiple different products from a single process.

This is where Formula Items and Planning Items come into play. These features are the backbone of process manufacturing. They allow companies to manage the complexity of recipes, varying yields, and the simultaneous production of multiple items. Understanding how to configure these items correctly is the difference between having an accurate view of your inventory and costs, or dealing with a chaotic system where your physical stock never matches your digital records. In this lesson, we will dive deep into the mechanics of formulas, the strategic use of planning items, and how to handle the "extras" that come out of your production line, known as co-products and by-products.

Understanding Formula-Based Manufacturing

At its core, a formula is a recipe. While a BOM is typically a list of components used to create a single finished good, a formula defines the ingredients required for a specific batch size of a product. Formula manufacturing is common in industries like food and beverage, chemicals, pharmaceuticals, and consumer packaged goods. The primary distinction is that formulas often account for ingredients that are measured in volume or weight (like liters, kilograms, or gallons) rather than discrete units (like "each").

When you configure a formula item, you aren't just saying "I need X to make Y." You are defining a relationship between ingredients that can scale. If you increase the batch size of your production run, the system must be able to calculate the proportional increase in ingredients. Furthermore, formulas allow for "Step Consumption," where certain ingredients are added only when a specific threshold is reached, or "Variable Consumption," where the amount of an ingredient might change based on the quality or potency of the raw materials available.

Callout: Formula vs. Bill of Materials (BOM)

While they might seem similar, the logic behind them is fundamentally different. A BOM is used for discrete items where the output is usually a single item and the components are fixed. If you need to make 10 chairs, you need 40 legs. A Formula is used for process manufacturing where the output can result in multiple products (co-products) and the ingredients are often proportional or based on a specific batch yield. Formulas also handle "potency," which adjusts ingredient quantities based on the active strength of a chemical or nutrient.

The Role of Batch Sizes and Yields

One of the most critical aspects of formula configuration is the concept of yield. In a perfect world, if you put 100 pounds of ingredients into a mixer, you would get 100 pounds of finished product out. In reality, evaporation, spillage, or chemical reactions often mean you lose some of that mass. Formulas allow you to define a "Yield Percentage." If your process has a 95% yield, the system knows that to get 95 gallons of finished liquid, it needs to plan for the ingredients required for 100 gallons.

This calculation is vital for accurate material requirements planning (MRP). Without a properly configured yield, your system will consistently under-order raw materials, leading to production delays. Conversely, if you over-estimate your yield, you will end up with excess raw material inventory that ties up capital and takes up warehouse space.

Configuring Formula Items

To set up a formula item, you first need to ensure the item itself is configured with a production type of "Formula." This tells the system to look for a recipe rather than a standard assembly list. Once the item is created, you move into the configuration of the formula versions.

Defining Ingredients and Proportions

When adding ingredients to a formula, you have several options for how the system calculates the quantity needed. The most common is "Proportional." If the formula is set for a batch of 100 units and requires 10 units of an ingredient, doubling the batch to 200 units will automatically double the ingredient requirement to 20 units.

However, some processes require "Fixed" quantities. For example, regardless of whether you are making 50 gallons or 500 gallons of a chemical solution, you might need exactly one cleaning filter or one specific catalyst packet that doesn't scale with the volume. Configuring these correctly prevents the system from suggesting you buy 10 filters when you only ever need one per batch.

Step Consumption Logic

Advanced formula configuration often involves "Step Consumption." This is used when the amount of an ingredient doesn't increase linearly. Imagine a scenario where you add one cooling agent for every 500 liters of product. If you make 1 to 500 liters, you need one unit. If you make 501 to 1,000 liters, you need two units.

The configuration usually looks like a table within the formula line:

• From 0 to 500: Quantity 1
• From 501 to 1,000: Quantity 2

This level of detail ensures that the production team has exactly what they need on the floor, and the costing department can track the exact consumption of expensive additives.

The Power of Planning Items

A "Planning Item" is a unique tool used in process manufacturing to represent a production process that yields multiple different finished goods simultaneously. Unlike a standard item, you never actually "stock" a planning item in your warehouse. It is a conceptual item used to drive the production of co-products.

Think of a dairy processing plant. They don't just "make" skim milk. They process raw milk, which results in cream, skim milk, and perhaps buttermilk. In this case, the "Raw Milk Processing" is the Planning Item. It holds the formula (the raw milk and enzymes) and defines the outputs (the various types of milk and cream).

Why Use Planning Items?

Planning items are essential when you cannot produce one item without also producing another. In the oil industry, you cannot refine crude oil into gasoline without also producing diesel and jet fuel. If you tried to use a standard formula for gasoline, the system wouldn't know how to account for the "accidental" production of diesel.

By using a planning item, you can create a production order for the process itself. The system then looks at the formula and understands that this single order will result in five different items being added to your inventory. This allows the planning engine (MRP) to see that a demand for gasoline will inherently satisfy a portion of the demand for diesel.

Note: Planning items are "Phantoms" in the sense that they have no physical presence. You cannot sell a planning item, and you cannot count it during a physical inventory check. Its only purpose is to act as a container for a complex manufacturing process that has multiple outputs.

Co-products and By-products

When a formula or planning item is processed, it produces the "Main Item" or several "Co-products." It may also produce "By-products." Understanding the distinction between these is vital for both inventory management and financial accounting.

Co-products

Co-products are items of significant value that are produced alongside the main product. They are usually intentional. In our dairy example, both heavy cream and skim milk are co-products. They both have market value, they are both sold to customers, and they both need to share the cost of the raw milk and the processing time.

By-products

By-products are items that are produced as a residual of the process. They may have some value, but they are not the primary reason for the production run. A classic example is sawdust in a lumber mill. While the mill is trying to produce boards (main product), sawdust is inevitably created. The mill might sell the sawdust to a paper factory or a particle-board manufacturer, but the value is much lower than the lumber.

In some cases, a by-product might even have a negative value if you have to pay someone to haul it away (like chemical waste). The system allows you to configure by-products so that their value is either credited back to the cost of the main product or treated as a separate minor revenue stream.

Cost Allocation Methods

One of the most complex parts of configuring co-products is deciding how to split the production costs. If it costs $1,000 to run a process that produces two different items, how much of that $1,000 belongs to Item A and how much to Item B?

There are two primary methods for this:

1. Manual/Fixed Percentage: You decide that Item A always gets 60% of the cost and Item B gets 40%. This is simple but doesn't account for market fluctuations.
2. Total Cost Allocation (TCA): This is a more dynamic method where the system calculates the cost based on the market value of the items produced. If Item A becomes much more expensive on the open market, the system will allocate a larger portion of the production cost to it.

Step-by-Step: Configuring a Formula with Co-products

Let's walk through the practical steps of setting up a formula for a chemical mixture that produces a main cleaning solution and a concentrated lubricant as a co-product.

Step 1: Create the Items

First, you must create all the items involved in the process.

• Item A (Cleaner): Set Production Type to "Formula."
• Item B (Lubricant): Set Production Type to "Co-product."
• Ingredient X & Y: Set Production Type to "None" (these are raw materials).

Step 2: Define the Formula

Navigate to the Formula management section for Item A. Create a new formula version and give it a description like "Standard Batch - 1000L."

• Add Ingredient X: Set quantity to 500L, consumption type to "Proportional."
• Add Ingredient Y: Set quantity to 500L, consumption type to "Proportional."

Step 3: Configure Co-products

Within the formula screen, look for the "Co-products" button. Here, you will link Item B to this formula.

• Add Item B: Set the quantity produced (e.g., 50L for every 1000L of Item A).
• Set the Cost Allocation: Choose "Total Cost Allocation" and assign a cost weight.

Step 4: Approve and Activate

A formula is not usable until it is approved and activated. This is a safety mechanism to ensure that recipes aren't changed mid-production without oversight. You will need to approve both the formula itself and the specific version you created.

Warning: Always double-check your "Effective Dates" on formula versions. If you activate a new formula version but set the start date to next month, the system will continue to use the old, potentially incorrect formula for current production orders.

Technical Implementation: Data Structure

For those working on the technical side or integrating these systems, it helps to understand how the formula data is structured. Below is a simplified JSON representation of what a formula configuration might look like in a modern ERP database.

{
  "FormulaHeader": {
    "FormulaId": "FORM-001",
    "Description": "High-Gloss Blue Paint",
    "Site": "Factory-01",
    "BatchSize": 100.0,
    "UOM": "Gallons"
  },
  "FormulaLines": [
    {
      "IngredientId": "RM-BLUE-01",
      "Quantity": 20.0,
      "ConsumptionType": "Proportional",
      "IsResourceConsumption": false
    },
    {
      "IngredientId": "RM-BASE-WHITE",
      "Quantity": 80.0,
      "ConsumptionType": "Proportional",
      "StepConsumption": {
        "Enabled": false
      }
    },
    {
      "IngredientId": "RM-CATALYST",
      "Quantity": 1.0,
      "ConsumptionType": "Fixed",
      "Note": "One packet per batch regardless of size"
    }
  ],
  "CoProducts": [
    {
      "ItemId": "CP-SLUDGE-RECYCLED",
      "Quantity": 5.0,
      "CostAllocationPercent": 10.0,
      "Type": "CoProduct"
    }
  ]
}

Explanation of the Code Structure

• FormulaHeader: Defines the "what" and "where." It sets the standard batch size which serves as the baseline for all calculations.
• FormulaLines: This is the list of ingredients. Note the difference between "Proportional" and "Fixed" consumption. The system uses these flags to decide whether to multiply the quantity by the production order volume.
• CoProducts: This section tells the system that for every 100 gallons of paint, we also get 5 gallons of a recyclable sludge. The 10% cost allocation ensures that some of the material and labor costs are moved from the paint to the sludge, providing a more accurate margin analysis for the main product.

Best Practices for Formula Management

Managing formulas is an ongoing process, not a one-time setup. As your manufacturing processes improve or your raw material quality changes, your formulas must evolve.

1. Use Version Control

Never overwrite an existing formula if the process changes significantly. Instead, create a new version. This allows you to keep a historical record of how a product was made in the past, which is vital for quality audits and regulatory compliance (especially in food and pharma).

2. Account for Scrap and Waste

There is a difference between yield and scrap. Yield is the expected loss inherent in the process (like evaporation). Scrap is usually the result of an error or a specific part of the process that is discarded (like the ends of a roll of material). Configure your formula lines with "Scrap Percentage" to ensure you are pulling enough inventory to cover these predictable losses.

3. Regularly Review Cost Allocations

If you are using co-products, the market value of those items can change. If a co-product suddenly becomes much more valuable, you should update its cost allocation. If you don't, your main product will appear more expensive than it actually is, potentially leading to bad pricing decisions.

4. Leverage Potency and Active Ingredients

In many chemical processes, the "strength" of a raw material can vary from batch to batch. If you receive a shipment of an active ingredient that is 90% pure instead of the usual 95%, your formula needs to adjust. Advanced systems allow you to flag an ingredient as "Attribute-based," meaning the system will automatically calculate how much more of the 90% pure stuff you need to meet the recipe's requirements.

Callout: The "Catch Weight" Factor

In many industries that use formulas, you also deal with "Catch Weight" items. These are items where the count and the weight vary. For example, you might use 10 wheels of cheese in a recipe. Each wheel is "one" unit, but they all weigh slightly different amounts. When configuring formulas for these industries, ensure your unit of measure (UOM) conversions are precise, or the system will struggle to calculate the actual mass being added to the batch.

Common Pitfalls and How to Avoid Them

Even experienced consultants and production managers can run into trouble with formula and planning item configurations. Here are the most common mistakes to watch out for.

Circular References

A circular reference occurs when Item A is an ingredient in a formula that produces Item B, but Item B is also an ingredient in the formula for Item A. This often happens in recycling loops. To avoid this, use a separate "Planning Item" to represent the loop, or ensure that the recycled material is treated as a "By-product" that is put into stock and then issued to a new order as a separate transaction.

Ignoring the "Flush" Principle

In many systems, ingredients are "flushed" (consumed) automatically when a production order is finished. If your formula is not set up with the correct flushing principle (Start, Finish, or Manual), you might find that your inventory isn't being deducted when you think it is. For long production runs that take days or weeks, "Manual" or "Start" flushing is often better so that the inventory is removed from the books as soon as it's moved to the production floor.

Incorrect Batch Scaling

If you create a formula for 1 unit of a product but your actual production run is always 10,000 units, small rounding errors in your ingredient quantities can become massive problems. Always define your formula batch size as close to your actual production run as possible. If you usually make 1,000 liters, set the formula for 1,000 liters. This minimizes rounding discrepancies in the math.

Over-complicating By-products

Not every piece of waste needs to be a by-product in the system. If the waste has no value and doesn't need to be tracked for regulatory reasons, don't create an item for it. Simply account for it as "Scrap" on the formula line. Adding unnecessary items to your system creates "data noise" and makes it harder for your team to focus on the items that actually impact the bottom line.

Comparison Table: Planning Items vs. Formula Items

Practical Example: The Bakery Scenario

To tie all these concepts together, let's look at a large-scale industrial bakery. They produce "Premium Sourdough Bread."

The Formula Item: The Sourdough Bread itself. The Ingredients: Flour, water, salt, and "Starter." The Proportions: Flour and water are proportional. Salt is proportional. The Step Consumption: The bakery uses a specific specialized yeast packet for every 50kg of flour. They set up step consumption so the system knows exactly how many packets to pull. The Planning Item: The bakery also has a "Dough Production" process. This process produces the dough for the bread, but it also produces "Excess Starter" which they sell to other smaller bakeries. The Co-product: The "Excess Starter" is a co-product. It has a high value and is sold as a separate SKU. The By-product: Flour dust and floor sweepings. These are collected and sold to a local pig farm for a very small fee. These are configured as by-products with a fixed value that offsets a tiny portion of the flour cost.

In this scenario, if the bakery gets an order for 1,000 loaves of bread, the system looks at the Planning Item. It calculates how much flour and water are needed. It also realizes that by making this much dough, they will also have 50kg of Excess Starter available to sell. If there was already a pending order for Starter, the system "sees" that this production run will satisfy that order, preventing the need for a separate production run just for the starter.

Summary and Key Takeaways

Configuring formula and planning items is about more than just data entry; it is about creating a digital twin of your physical manufacturing process. When done correctly, it provides a level of insight into your operations that allows for leaner inventory, more accurate pricing, and smoother production scheduling.

• Formulas are for Recipes: Use formulas when you are dealing with ingredients, batches, and yields rather than just assembling parts.
• Yield is Critical: Always factor in the expected loss of materials during production to ensure your planning engine (MRP) orders enough raw material.
• Planning Items are Process Headers: Use them for complex processes where one set of ingredients results in multiple distinct finished goods that all need to be tracked.
• Co-products vs. By-products: Distinguish between items of significant value (co-products) and incidental leftovers (by-products) to ensure accurate cost accounting.
• Consumption Logic Matters: Use proportional consumption for most ingredients, but don't forget "Fixed" and "Step" consumption for catalysts, additives, or packaging materials.
• Cost Allocation: Choose between manual percentages or Total Cost Allocation (TCA) based on how much market price fluctuations affect your business.
• Version Control: Always use approved and dated versions for formulas to maintain a history of your manufacturing processes and ensure regulatory compliance.

By mastering these advanced product information features, you move beyond basic inventory management and into the realm of true process optimization. Whether you are mixing chemicals, baking bread, or refining minerals, these tools provide the flexibility needed to handle the inherent variability of the physical world.